!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.

I've attached the mdb (very small).

Thx for the assistance.

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 …

http://www.databasedev.co.uk/forms.html

Keep us posted on your progress!

Bill