Form to display specific query results based on user input

[Zako]

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

 

[Autoeng]

I'm confused. Is it that you don't want the criteria boxes to pop up? How else would the query get the criteria to run on unless this happened? You can create a form to enter the criteria in and then point the query criteria to that form field but I don't see much difference in that vs. the generic popups the system provides for criteria.

Please offer a little more explaination.

 

[Autoeng]

Oh, I think I understand now. You want to be able to search on any field but if you haven't entered criteria for a field you don't want to be prompted for it, correct? Try www.mile50.com for the utility FFil. It will do what you want but it, as far as I know, will alway take a secondary form to eliminate the secondary query requests for empty fields.