Creaing report

[Guest]

I have a form where I am collecting orders information for each customer. On
this form I also have a sub form showing me all orders for specific customer.
I would to select specific order id and create report only for that order
id. Order Id is a primary key in Order table. Thanks

 

[Guest]

Hi Greg,

If I read you right, the order you want to print the single report for is in
the subform, if that is the case, then you can have a query that references
the selected order like this:

select * from tblOrder where OrderID =
forms!frmMainform.subfrmSubform.form.lngOrderID

if it lives on the Main form, not the subform, then remove the
subfrmSubForm.form. portion of the above query.

Hope this helps!

Damian.

 

[Duane Hookom]

Check this link http://www.mvps.org/access/reports/rpt0002.htm.