Hello,
I am looking to create a form that will allow me to search by multiple fields (lets call these A B C D ….). I would like to be able to type a value for field A, and have the same form populate the other fields with matching records.
In addition, I would like to be able to type in values for both fields A and B, and have the same form populate the other fields with matching records.
I have created a search form that uses a search button and a query to crawl through records. Is this the best way to accomplish this?
The issue I have come across deals with the fact that I have multiple empty records in multiple fields. This has prevented all relevant records from being returned. Only records with all fields filled were returned.
I have used the Criteria: [Forms]![Search]![A] Or Like "*" & "*" . Upon opening the Query, I am asked to give parameter values for each field.
Where do I go from here?
Thanks