G
Guest
I am trying to create a search form that will retrieve records displayed on another form. What I want is a form that has several fields and one button. The user should be able to enter as much information into the fields as he/she knows (leaving some fields blank) and click "search." The query should take into consideration the data in the fields and disregard fields that are left blank. I have gotten to where the macro goes field by field and accepts or disregards the field as criteria, but it runs a new query for each field instead of quering the filtered records. For instance, if two fields have information in them, I need the first query to run and then the second to filter the records returned from the first query. As it is right now, the second query filters all the records instead of the first filter results. This is sort of confusing, but I am about desperate. There may be better way to do it all together, but I don't know what it is . . . PLEASE HELP!