Link to home
Start Free TrialLog in
Avatar of JermyD
JermyD

asked on

Only Print Data Report for Current Record

Hello

I have a Data report made from the designer.  I'm using a Data Environment connection, linked to an Access db.  On click of a button on vb form, I'm showing this report, but it displays all records.  I went to the 'Advanced' tab on the Command properties and unchecked the box 'All Records' and specified a max of 1 record, nut still the report shows all records.  I was wondering if there is a way to show the report for only the current record in the vb form?

Any help would be greatly appreciated.

Jeremy
ASKER CERTIFIED SOLUTION
Avatar of Éric Moreau
Éric Moreau
Flag of Canada image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Recommandation: Points to emoreau
Avatar of JermyD
JermyD

ASKER

The link goes to a good article on how to refresh a data report using the CDate function.  I'm having trouble using this info to solve my problem.  I'm trying to print only the current record in a Data report.
This articles shows how to create a command that receives a parameter to filter data and print only those filtered records.

Change the date to your record ID and your job is done!