The form must be unbound. The Model field will be a combobox. You could display the data below in a subform by using a filter in the AfterUpdate of the model without the need for the run query button.
Thank you,
I've recreated the form (with UNBOUND fields) and the query. They work fine on a few models, but the query remains blank on other entries.
The problem now is when I enter some information for a search like LT-48(E) in the Model field, and click the run button. The query returns a blank result (there happen to be 12 entries for this model in the Mod Table. The same thing happens when I enter just LT in the field. It should return all entries for our 5 LT series models (over a hundred), but remains blank.
I entered SB in the Model field and the result was anything with a B in the name:
So how do I fix this so that when a text string (and all the fields ARE text strings) is entered, all the results appear???
FYI, I've re-created the form and query. Here are the design & query views:
Form:
Query:
Many thanks,
You have an AND in the query - like model AND like eco. That requires that both fields are filled in on the form for your query to return results.
Does the query produce the results that you are expecting? That is how you will know if it works. Have the form open, type in model numbers, run the query and compare it to the records on the table.
For a search form, I prefer to use code and filter the data.
Thank you for the information and the zip file.
Unfortunately, my boss refuses to pay for me to take coding classes.