Print current record ONLY

[Marleen Hart]

I created a form with a control button which automatically prints a particular report.

My problem is that the correct report prints, but I get one report for each record in the table. I want only a single report for the one record which is the current record showing in the form.

Example: The form is for entry of registrants for a conference. The button prints a report which is a receipt for the one attendee who was just registered. Clicking the button on the form prints the correct receipt with correct attendee name and fees, etc. but I get one report for all the other attendees as well. Not good!

Please help me!

 

[Anauz]

how do you select which record to print? ie do you select a memberid in a drop down box or something?

 

[Chris RR]

Base your report on a query. The query should then use the registrant's ID (from your form) as its criteria.

 

[Dabni]

Chris,
How do you do this? By setting criteria in the query?

 

[Robert Dunstan]

In order to set the criteria for the query to get the current record for your report use this expression in your ID field

=[Forms]![YourFormName]![YourControlName]

HTH
Rob