Search based on multiple Criteria (1 Viewer)

[Mickster]

Hi there i am building a search form and I want it to be able to display results from multiple criteria......Currently I am able to display results in a listbox, whenever the user types in a id number in a text box. So if a user types 63 in the ID text box the record with and ID of 63 will appear in the list box or it will wont if the record does not exist..... What i want to do is be able to search on multiple criteria. Sof if a user wants to search based on a name instead of a id number they woudl be able to. What I am struggling to grasp is how to invoke a OR in the criteria box. So that the list box will display results based on either the ID text box OR the name text box.

Any thoughts?

 

[Cire]

have u take a looked at this thread?
http://www.access-programmers.co.uk/forums/showthread.php?t=107647
i've answered many questions about multiple criteria search in there. however VBA coding is used so it would be good to read up on it beforehand.