parameter with or clause

[ootkhopdi]

Sir
i have two forms
Form 1 with combo box 1
form 2 with combo box 21
i set run query A with parameter as value of combo box 1 of form 1
i want to run same query (Query A) with parameter as value of combo box 21 on form 2 or combo box 1 on form 1

how can do this
pls help me

:banghead:

 

[Mihail]

Write in a Public (regular) module this code:

Public VarName

Public Function ReturnVarName()
   ReturnVarName = VarName
End Function

In the query, use ReturnVarName() as parameter.

Manage that the VarName to be filled with the combo value before to apply the query:
So, in the form module, use this:

VarName = Me.Combo1 '(or = Me.Combo21)
'Code to open the query