Printing Report, one page only

[Robert]

Hi -

I have a form (Orders) and a report (Invoice). On the
form I have a command button (Print Invoive) that when
pressed, I would like it to print the invoice for that
specific order only. What is happening now is that it is
printing all the invoices at one time. Any suggestions?

Thank for your help!
Robert

 

[fredg]

Hi -

I have a form (Orders) and a report (Invoice). On the
form I have a command button (Print Invoive) that when
pressed, I would like it to print the invoice for that
specific order only. What is happening now is that it is
printing all the invoices at one time. Any suggestions?

Thank for your help!
Robert

Hopefully, each record in your Orders table has it's own unique prime
key number.
Let's assume this prime key field is named [OrdersID] and it is a
Number datatype.

Code the command button's click event:

DoCmd.OpenReport "Invoice", acViewPreview, , "[OrdersID] = " &
Me![OrdersID]