query citeria on a form

[Peter]

Hello,

Can anyone tell me how to link a field on a form to the "Criteria" part of a
query like you fill in the a criterion in the QBE?

The idea is to find the data that belongs to one object number that are
gathered in two tables. One table containing client info, the other
containing productinfo.

TIA
Peter

 

[Jeff Boyce]

Peter

Take a look at Access HELP on "expressions". The reference can be generated
by using the wizard in the query window, from the criterion field (and
selecting the form and control), which will give you an expression something
like the following:

Forms!YourFormName!YourControlName