Query performance when referencing form controls

[Bcanfield83]

I have a couple of queries that use parameter values taken from controls (combo boxes) on a form, e.g.: there's a couple fields that have the below listed as the criteria:

[Forms]![frmMenu_Reports_Main].[SubformContainer]![cboRole1]
[Forms]![frmMenu_Reports_Main].[SubformContainer]![cboRole2]



The queries take a good 20-25 seconds before the output is produced.. Yet, if I run the queries after tweaking them to include in a specific value in those 2 fields (versus pulling values from the combo boxes on the form/subform), they take all of 1 second. So clearly it is the form parameters slowing it down.
The tables used in the queries are linked via an ODBC Connection (to an Oracle DB). So I thought of using a Pass-Through Query instead, though I don't think there's a way to pass a value from the form into a Pass-Through Query, correct? Would it need to be done through VBA?

[ranman256]

are you sure this is the correct object path? (use the BUILDER)
it should be:

[Forms]![frmMenu_Reports_Main].[SubformContainer].form![cboRole1]

And why query objects in the subform?
put the query in the subform and the param is: me.cboRole1

[Bcanfield83]

You're right, when using the builder, the references were updated to: [Forms]![frmMenu_Reports_Main]![SubformContainer].[Form]![cboRole1]
Though it also worked when entering "[Forms]![frmMenu_Reports_Main].[SubformContainer]![cboRole1]".
To improve the performance, I created an initial pass-through query which creates a temp table. In the temp table, I indexed the fields being used as parameters in the query.

[June7]

Can't use Me. in query or in Access objects/controls/properties, only in VBA.