Using subform criteria to search the main form data

[treebark]

So my subform is an editable table where I can put multiple different columns of data:
ID, Order Number, User Name, User Location



I want to setup an apply filter search button so that when I enter multiple IDs or multiple Order Numbers and click the macro apply filter button it filters the main forms data based on all values in those columns. I have a button on the main form with an applyfilter macro that works great with one value, but it doesn't like the subform values as the filter criteria.

Thanks as always

[ranman256]

you want another table, say: tPicked
this would hold the many chosen IDs (I use a form so the user can dbl-click it)
In your main form query, join the tPicked table to your data and only these items will show.
The subform is bound to the main form so you get those too.

you can just manually enter data into the tPicked table, or use a form (below) to help:

[ssanfu]

So my subform is an editable table where I can put multiple different columns of data:
ID, Order Number, User Name, User Location

I want to setup an apply filter search button so that when I enter multiple IDs or multiple Order Numbers and click the macro apply filter button it filters the main forms data based on all values in those columns. I have a button on the main form with an applyfilter macro that works great with one value, but it doesn't like the subform values as the filter criteria.

The subform should NOT have a Main form/Child form relationship.
I never use macros, only VBA.
But using VBA, you could create a filter string and apply it to the main form. Since you are using a table, you would open a record set based on that table and build the filter string "on-the-fly", then apply it.

Because you want a filter that "filters the main forms data based on all values in those columns", it will be complicated.
One field "ID" is easy. Four fields get complicated fast.



BTW, "ID" is a poor field name.
And shouldn't have spaces in object names.

[treebark]

BTW, "ID" is a poor field name.

This is just an example, I cannot reveal my actual data. I'm well aware that is a terrible field name

[treebark]

What does the data macro look like for the Accept button?

[ssanfu]

This is just an example, I cannot reveal my actual data. I'm well aware that is a terrible field name

Great! As long as you know. I see so many dBs that have "ID" as the PK field in EVERY table.

Good luck with your project.......