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!

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

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

If you look up the OpenReport Method in help, you'll see the option for setting a filter.

Usually, if you have the wizards turned on, you'll see "just seleted data" as an option on one of the wizard forms as it guides you through the process.

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

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