Hi all, I've been looking through the forums and cant seem to find what I want.
I have a database that includes fields such as Firstname, Lastname, Phonenumber, Ordernumber, Serialnumber and Casenumber.
I have forms that allow data entry and data edit. I need a form that allows the users to search for all records based on criteria in one field. I.e. If they search by first name and type "john" the form displays all records with the Firstname field matching. (it could be a wildcard match like *john*)
What I cant figure out is how to make the query do this without popup boxes asking for criteria for each field in the query.
I do expect there will have to be a button that runs the query. Can anyone direct me to the right place to find this answer? ...or maybe tell me what I need to do for this?
Thanks
I have a database that includes fields such as Firstname, Lastname, Phonenumber, Ordernumber, Serialnumber and Casenumber.
I have forms that allow data entry and data edit. I need a form that allows the users to search for all records based on criteria in one field. I.e. If they search by first name and type "john" the form displays all records with the Firstname field matching. (it could be a wildcard match like *john*)
What I cant figure out is how to make the query do this without popup boxes asking for criteria for each field in the query.
I do expect there will have to be a button that runs the query. Can anyone direct me to the right place to find this answer? ...or maybe tell me what I need to do for this?
Thanks