query with options into a form

[smiller]

I would like to put a query into a form so that I can look up a part number, order number, or both, and then open the form for editing. I set up the queries but can't get them into the form. How would I go about doing this? Thanks for helping.

 

[Banana]

Search the forums on "Cascading Comboboxes". That will help you narrow the search and when someone select the part on the last combobox, you can run code to open it.

HTH.

 

[smiller]

sorry but where do I find the forums on "Cascading Comboboxes". I am having trouble locating them.

Also is there anyway you could tell me how to at least put one query into a form. That will be enough to get me started.

Thanks

 

[Banana]

Sorry, I forgot that it was prior to forum's hacking.

Here is the post with a sample for cascading combobox.

This will help you narrow your search, then when you have made an selection, you can open the approritate form using Where argument retrieved from the selection in the combobox.

HTH.