just print one register

F

filo666

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.
 
S

Sprinks

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
 
Top