query citeria on a form

  • Thread starter Thread starter Peter
  • Start date Start date
P

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
 
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
 
Back
Top