Search Form Based On Query

[james_IT]

Hi people,

i have a search form with a list box. it is based on a query. it works fine for a different project but in this project i need to search for either a perfect match for an ID, or a 'like' match for description, or a like match for the customer.

i want the list box to have the

EventID, Description, CustomerName, CustomerSurname, EventDate

i want to choose which information i enter into the unbound boxes to return results in the list box.

What formulas would i need to enter into my query as a criteria so that it works.

Thanks guys, james

 

[EMP]

Try Jon's basic criteria format in this thread:
http://www.access-programmers.co.uk/forums/showthread.php?t=103312

^