Printing Report, one page only

  • Thread starter Thread starter Robert
  • Start date Start date
R

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
 
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
Click to expand...

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]
 
Back
Top