How can I print a single filtered record on a form

  • Thread starter Thread starter Robert Sharp
  • Start date Start date
R

Robert Sharp

I am having trouble printing a single filtered record
from my form, I created a cmd button to print record but
it prints my entire database. How can I print the single
record and also send that single record to word for a
mail merge.

Any help would be appreciated

thanking you in advance

Robert
 
Robert

If you have a cmd button, it probably uses the

DoCmd.OpenReport

command. Take a look at Access HELP for the syntax of OpenReport. It
includes a method for including filtering/WHERE information when the report
is opened.
 
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

How do you print one record from a Report? 1
Trying to print current record 1
Form filter then print report 2
Printing a report for a single ID 1
Openreport Method and filtering 4
Printing report with single record data from a form 3
Having problems printing a single report 3
Print just the current record showing on the form 4

Back
Top