specific report viewing

  • Thread starter Thread starter delf
  • Start date Start date
D

delf

when in a form with an autonumber where several tables are
connected, I would like to be able to click a button and
view the records that correspond to a specific reference
number. How can I do that without showing all the records?
Tx
 
when in a form with an autonumber where several tables are
connected, I would like to be able to click a button and
view the records that correspond to a specific reference
number. How can I do that without showing all the records?
Tx
Click to expand...

Code a command button click event:
DoCmd.OpenReport "ReportName", acViewPreview, , "[RecordID] = " &
Me![RecordID]

Change [RecordID] to the name of whatever field is the record's Prime
Key field.
 
Back
Top