I have created some parameter queries (they ask for user input).
I want the user to input the required parameters not from the input box of the query but from a textbox located in a form.
i.e. The user enters a value in a textbox of a form. I want this value to be used as a parameter to open the query.
How can I do that?

You can write a dLookup function in VB as an event on the form. Pass the value of the drop down box to the VB event and have it return the value(s) that you are looking for.

If you can, give me an example of the type of recordset to be returned by the query and I'll send you some sample code that might work. Also, indicate what you will be doing with the returned info

John

PS

You can also use a button on the form that the user would press to run the query.

Simply use the syntax forms!'formname'!'fieldname' as the criteria in the query design. Again, if you send me youor end goal I'll give you some coding hints

John

This second suggestion is exactly what I was looking for.
Thanks a lot, John.
You have been very helpful.