Printing Record

[Guest]

Hi,

We use one Main form that has 5 tab controls, each with one subform, to log
in jobs that come in to our department. You can scroll through all active
jobs.

We identify individual jobs in queries by using a combination of the Job Id
field and the Date/Time Submitted field (Job Id starts at "1" at the
beginning of each day).

I would like to add a command button that will print a job ticket for each
job. I would like to print this ticket two times - once after all job
information is logged into the Main form (to be sent to the worker with the
job), and once when the job is checkmarked "Completed" (to be sent back to
the job requestor with their completed work).

Where would I place the command button, how would I select the job I want to
print the ticket for, and can I just use a simple command, or do I need more
complex code?

Many thanks,

 

[Allen Browne]

Create a report that prints things out the way you want it to look.

Then in the Click event of your 'Print This Record' button, use the
WhereCondition of the OpenReport action so the report prints just this one
record.

Details and example in this article:
Print the record in the form
at:
http://members.iinet.net.au/~allenbrowne/casu-15.html