How do I print just current record in a report, when there are ov.

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

Guest

I have a database with 7000 records, I have a command button set to go from
the form to a print preview of the report. When I click the button it goes
to the first record not the current one I am on, how do I set to open only
current record. In addition how do I set to print only the current record,
not the whole database of records. I also need this macro or event procedure
so I can email only one record not the entire database. I am a novice at
macros and event procedures, any assistance would be appreciated.
 
If you look in the OpenReport Macro action, there is a "Where Condition"
argument that you can use to filter the Report's RecordSource to just the
current Record on the Form.

The same is true for OpenReport Method in VBA.

Check Access Help (Macro) or Access VB Help on OpenReport.
 
Back
Top