Using a form to enter query criteria..

N

NoviceIan

I have designed a form which will select a staff member using a combo box and
have also added OK and Cancel buttons. I am trying to attach this form to a
query so that data will only be returned on the person selected using the
combo box.

I am looking for the statment that will need to be added to the relevant
field on the query if anyone can help me I would be very grateful. Thanks

Ian
 
R

Rick B

Put something like the following in the criteria under the desired column...


=Forms![MySearchFormName]![MySearchFieldName]
 
Top