querie - restrict reslts to records which match value in a form fi

[Guest]

I'm trying to populate a select list from a table, but need to restrict the
list to those records which match a value which has been entered into a form.
As an example assume i have a table named cars which holds records for
different types of cars. One field is for make, another specifies body type
(style). I want to be able to retrieve all records for a particular make, but
i don't want to ask the user which one they want as they have already entered
this in a field on a form named car finder.
Can this be done?

 

[Guest]

Certainly. In the criteria of the query put something like below that
matches the information on the form:

[Forms]![frmCars]![txtMake]

There are a couple of gotchas. Combo boxes can sometimes be a little
problem. The form must remain open for this to work; however, you can make it
invisible if you want it to get out of the way.