Search form database

[Jan22]

Hello everyone!



I'm working on a project here in Holland to design a database in which laser weld parameters can be put in. Now i'm building up a search form in which
users can dynamicly search. The dynamic search is working:
1. query created
2. Textbox created (input)
3. Unbound combobox (results)

I have put in a code that compares the input with the qeury and then requery's it into the combox.
This is working fine.

But now I want to filter in specific columns to create a more reliable search form:

I allready have put five different combo boxes in the form and pasted the code to filter.
But the problem is that this query that I have created searches in all the columns for the answers instead of just one (what I need)

I can create another query to search in a specific column but then my results would be in another combobox which is not something I want.

Could anyone help me out with this?

Here's a part of my database (search form, query, etc.)

[Jan22]

Updated my uploaded file.

[June7]

Put all criteria on a single row so AND operator is invoked, not OR http://www.datapigtechnologies.com/f...earchform.html

Not sure what issue is. If you want to input criteria into only one combobox and filter with that value, should work.

Rather hard to test when data in table does not match the choices in comboboxes.

[Jan22]

Thank you! are there more turitorals like that one?

[June7]

From the same source http://www.datapigtechnologies.com/AccessMain.htm