just print one register

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

Guest

I have a report related to a form (that is related to a table with 54
registers), when I put print on the reporte it prints the 54 registers, I
just want to print the register that is shoen in the form, how could I print
just one register.
 
Hi, Filo.

Open the report and set the Filter and FilterOn properties to filter the
report by the current record's primary key:

DoCmd.OpenReport "YourForm", acPreview
Reports![YourForm].Filter = "YourPrimaryKey = " & Me![YourPKFormControl]
Reports![YourForm].FilterOn = True

Hope that helps.
Sprinks
 
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

Struggling! Please help! 0
How to see hidden text in a row 1
Printer printing larger than actual scan size 10
Excel VBA - Problem with Closing Print Preview 0
Epson XP-3150 not printing 2
Mailmerge using he or she 3
register student to course 0
Access Sorting and grouping using multiple tables 0

Back
Top