print a record

S

Shari

I have a multi user application and I would like the user to be able to print
a report anytime after they have submitted the data. The user inputs data on
a form. The user may need to print a report of that data a week later. Is
there anyway for the user to view and/or print just the record they submitted?
Shari
 
A

Arvin Meyer [MVP]

The line of code for a command button on the form with the record to be
printed:

DoCmd.OpenReport "ReportName", acViewPreviw, , "IDField = " & Me.txtIDField

where ReoportName is the report's name, IDField matches the ID field name
and txtIDField is the name of the textbox for the IDField on your form.
 
Top