Open a form based on a query, based on Combo box choices

[ScorpioX]

Hi All,
Is it possible to open a template form, based on a query? Which will contain data based on selections made from three combo boxes.
Basically the user will choose a Category, type, and model. Which will then open a template form, populated with the data from a query based on the say the model chosen. I believe I have the query problem worked out, but I am not sure how to link the query to the form.

Any help is appreciated,
ScorpioX

 

[PHV]

Bind the form to the query (RecordSource property).

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[ScorpioX]

Hi PH,
Thank you for you reply. What I think I want to do is open the form based like below:
Say the user chooses "Truck" as the model. Then the form would open with the truck query, populating the truck data.
Say the user chooses "Car" as the model. Then the form would open with the car query, populating the car data. Basically one form with multiple queries, based soly on the model they choose. I am not sure if this is even possible. Maybe I am looking at this wrong. I am trying to use templates but want to limit the amount of forms.

Thanks,
ScorpioX