passing query parameters from within form to get results in a subf

S

stevea36

I have a query defined that accessses many sql datasets and does some
calculations. This query requires 3 inputs (item, lot, whse). How can I set
up my form/subform to provide input boxes for these fields and then use the
fields in the query to get the output in the subform.
 
R

Rick B

Did you search the group for your answer first? This is posted all the
time.

Create your form, then use the following as your criteria in the query...
Forms!SomeFormName!SomeFieldName
 
Top