I have a passthrough query which in order to work needs a parameter sent to it to filter criteria based on value(s) on various forms.
I got the passthrough query to work with no criteria --- and then I created a second query pulling the passthrough in as the table/source for the second query and applied the criteria that way.
Do you see any problem with that? I want to filter the contents of combo boxes based on values in other fields and thought a passthrough query would be the way to go -- I know I can create code to create the queryDef -- but wondered if what I'm proposing makes sense.
It works, but just wondered if it's an acceptable method.