Query based on forms data? How

[Zholt]

I want my users to select criteria in a form .

I need a query to then search through a table and display the available results in a drop down box.

I have looked at cascading combo boxes but i just can't seem to understand them.

I appreciate your time and any help that you can offer

 

[gadjet]

In the query place the reference to the control on your form, like this

forms!frm_your_form!combo18

Then when you call the query it will use the data from the controls on the form as the criteria for the query.

I don't know about the dropdown box though....

 

[Zholt]

This is what has been asked and I don't know where to start.
Please read and comment how you would go about it.