Printing from a form

K

Kevin

I have created a job numbering system, i need to be able to print the job
once i have entered the data into the form, but i don't want all the data
printed, such as subform. What is the best way to print a document that i can
issue to the workshop and create a semi proffesional looking form
 
S

strive4peace

Hi Kevin,

make a report whose recordsource is all your jobs -- then, put a button
on the form to print a report for the current record

DoCmd.OpenReport(ReportName, View, FilterName, WhereCondition,
WindowMode, OpenArgs)

for example:

DoCmd.OpenReport "MyReport", acViewPreview,,"RecordID=" & me.RecordID

where RecordID is the name of your primary key field

Warm Regards,
Crystal
*
:) have an awesome day :)
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*
 
S

strive4peace

you're welcome, Kevin ;) happy to help

Happy New Year to you too!

Warm Regards,
Crystal
*
:) have an awesome day :)
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*
 
Top