Multiple criteria in where clause to open a form?

[HiGu]

Is the following statement correct/

DoCmd.OpenForm Me.Name, , , "[A_PRIORITY] = '" & _ cboPrior & "'" AND "[A_LOCATION] = '" & _ cboLocate & "'"

I am trying to give two conditions to open a form here.However nothing happens.

[NeoPa]

No. It has various problems, mainly related to what is inside, and what is outside, your string values.

Try something like :

Call DoCmd.OpenForm(FormName:=Me.Name, _
                    WhereCondition:="([A_PRIORITY] = '" & Me.cboPrior & "') AND " & _
                                    "([A_LOCATION] = '" & Me.cboLocate & "')")