!Simple! Access 2003 Form w/ SubForm Query Issue/help
tblModelColor: 4 fields, MODEL, COLOR, START, STOP vwModelList: contains all the tblModelColor fields vwModelList_subform: form in linear form of vwModelList frmModelColor:
No Header
Detail: Has sub form query that has the 4 fields from tblModelColor
Footer: has a cboModelName, cmdShowAll, cmdRunQuery
Problem:I'm trying to allow the user to pick from list MODEL or type in a wildcard like Model_* . Which should return all Like MODEL_* in the Details section of the form.
Currently when I select the MODEL or type MODEL, I get a parameter dialog box. Forcing me to input the MODEL again, before displays all the MODEL.
Question: How can I get all like MODELS to automatically populate in the the sub query form with out making the user double enter or select and then enter the text again in the dialog box.
In the spirit of "teaching someone to fish," (you'll have far more questions as you proceed, and as your skills evolve, I'm sure you realize), here is a pretty comprehensive list of dozens of other practical MS Access Forms procedures for things that developers like yourself often find themselves doing.
Most make available downloadable code and other samples! Excellent template material! The “library” of “how-to’s” here is quite impressive …