print a record

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Creating a Report from a Form 2
How can we convert OST to PDF file format? 1
Get current record only to show on report 3
New Record 4
Email report that is filtered to one record 7
printing 1 sheet of report 1
Updating tables when you input new data 0
Add record to table 1

Back
Top