Printing Records

  • Thread starter Thread starter Sandy
  • Start date Start date
S

Sandy

Once I have completed details on my form 'Customer_Details' with subform
'Job_Details' (Job_Details is the many sided part), I would like to print
off only that record (current visible record) from my report -
'Customer_Orders'.

My thoughts were to have a button on the form to issue the instruction to
print - (2 copies would be ideal - one for the customer and one for the
department to instruct the job).

Can anyone point me in the right direction on how to achieve this?

Sandy
 
You aren't very clear. you seem to be using the terms "report" and "form
interchangeably. They are NOT the same.

On your FORM, when you have a specific record visible, you can have a button
that you can click to open a report. You can source the report via the key
field in the displayed record. You can provide a value for number-of-copies
in the DoCmd.OpenReport command that the button references when clicked.
 
Hi Dennis,
Sorry for confusing you but in a nutshell I wanted a report, to contain only
the current record showing on my form so that I could then click a command
button, on my form, to have the report print, showing only that one record.
(Preferably two copies.)

I hope that is a bit clearer. (The following might explain a bit better).

However I finally found an article explaining the best way to do this was by
setting the report up from a query that shows only the current record
displaying on the form.

Link here;
http://en.allexperts.com/q/Using-MS-Access-1440/Report-record-1.htm

Sandy
 
Back
Top