ComboBoxe (Same Name) on Multiple forms - would like to filter Query with the CBO on the current for

[crimedog]

I have a Query that is filtered by a combo box - there are several duplicate forms with the same comboBox on them

I thought I saw that you could use [Form].[cboCompany] instead of [forms]![Form1].[cboCompany]

If I could reference the open form - I would not have to build the same query 10 times.

[June7]

This is one reason I don't use dynamic parameters in query. I use code to pass filter criteria to form or report when opening.

DoCmd.OpenReport "report name", , , "ID=" & Me.cboCompany