I have problem with my project and I need help with the solution.
1. Query name “A” has column1...column10
2. Form name “B” with subform “C”
In the subform “C” is connected source as query “A”...
My question is how I may update query “A” results if I want to use default filter (any search box any combobox) from all columns in the subform “C”
I thought that subform “C” is the same as query “A” but If I use filter in column1 in subform “C” then not update filtered result in query “A”
with one column is not problem, for example if in the query “A” for column1 give criteria Forms!B!C!column1 then from form is function update query result... but I can’t combine more criteria for each column in query “A”
Is possible please to used column filter for update query?
-In query “A” re the all data
-Users can use filter for each column in subform “C” and then export filtered data to excel with command button or print.
thanks for reply and sorry for my english ;)