Need to reset search form - Part 2

[rebfein]

The Result:





So, how would you suggest that I stabilize this form/query to have my boss type in the model number and view the all the data.

Also, how can I reset the form so that he doesn't have to exit everything and start over?

Many thanks,

[aytee111]

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.

[rebfein]

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,

[aytee111]

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.

[rebfein]

Thank you for the quick response,

FYI, the combo box is a good idea, but not practical for our needs as we have over 500 products, of which 443 are still active.

I changed the query to the following:


What do you think?

[aytee111]

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.

[ssanfu]

For a search form, I prefer to use code and filter the data.

[rebfein]

Thank you for the information and the zip file.

Unfortunately, my boss refuses to pay for me to take coding classes.