trying to do this correctly open form custom parameters

[Ruegen]

DoCmd.OpenForm "frmSchools", , , "SchoolTypeID = 2" & "StateID = 2" I need the query to have 2 custom parameters on the form that is being opened...

not aware of the correct language

[June7]

"SchoolTypeID = 2 AND StateID = 2"

If you want the criteria to be dyanmic, options:

1. popup input parameters in the form RecordSource (I never do that)

2. reference controls (comboboxes?) on form for the input
"SchoolTypeID = " & Me.cbxSchool & " AND StateID = " & Me.cbxState

3. popup VBA InputBoxes for criteria input

[Ruegen]

the top instructions work perfectly - I tried everything but​ that - thanks