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

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

Van T. Dinh

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.
 

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

Remain on current record after requery 1
Access Access Report Works on One Machine but not Another 3
Print current record to a grouped report 1
A macro to do the open several reports to print 4
Macro to automatically print current record on update to a report 5
Access 2010 Report Button 0
Trying to print current record 1
Pop-up form that creates record that links 1:1 to main form 0

Top