Print by Group

[rumpel07]

Hello,
Im new with access. I just created a form coming from our ERP Database that can generate a Work Order based on the Sales Order. my question is on how to print the form individually by required date. right now when i print it, it will print the whole data (containing different due dates)...

[pbaldy]

Forms are for interacting with data, reports are for presenting/printing. Printing a form will print all the data in its record source. Try a report that is either based on a query with a criteria or opened with a wherecondition:

http://www.baldyweb.com/wherecondition.htm