Multiple Criteria in same Query Field?

[Sticker Tires]

Is this possible? If so can someone explain how to accomplish it?

I have a query in which one of the fields criteria is based on an unbound combo box on a form, [Forms]![Form A]![CMB1].

I'd like to add this criteria to the same field, [Forms]![Form B]![CMB1]. Is it possible to have the query look for the criteria in Form A OR Form B?

Thanks...Ed

 

[namliam]

Yep and its even easy... So easy even that your giving your own answer...
"the criteria in Form A OR Form B"

Put this into the criteria

[Forms]![Form A]![CMB1] or [Forms]![Form B]![CMB1]

And you have your answer...

Regards