Query by Form Help

[Jim2001]

I have a Workorder database and I am trying to setup some searches (query by form). What I would like to do is open a form with the fields: orderno, status, problem, and equip in it. Instead of using simple parameter queries I would like to just have the user fill in the blank fields with the search criteria they want and then click a run query button and have the results show up on another ResultsForm. Is this possible without having to get into alot of VBA? I can make it work by using "Like" criteria, but I don't want it coming up asking for each field.

Thks in advance

Jim

 

[DJN]

Try the Microsoft Knowledge base. They have an article that may do what you want. the address is

http://support.microsoft.com/support/kb/articles/Q136/0/62.asp?

 

[JimUK]

Thanks tha looks just like what I need.



Jim