Printing Records

[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

 

[Dennis]

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.

 

[Sandy]

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