Printing a Form with a sub form built in using Access 2003.

C

CaptAdmCoy

I have designed a Work Order Form. This form contains a sub form.

When I print the work order it prompts me to enter the criteria for the sub
form. When I print three copies of the same work order it prompts me 4 times
for the sub form criteria.

How would I eliminate entering the Sub form Criteria so many times.
 
E

Eric Blitzer

if you are trying to print a form that is a mistake. Forms are for viewing
and editing data. Create areport based on a query getting the info from the
form.

To get the criteria information from the form.
In the criteria for the query of the report use
[forms]![nameofform]![textbox]
 
Top