HELP!!! - The enter parameter value box

[randypuppy]

I've set up a query which is linked to a report. I've set up the report to create membership cards for my customers.
When the report is run a card is displayed for each customer. So in the design view of the query i've set the criteria for customer ID to [Enter customer ID]. Then when the query is run, the enter parameter value box appears - I type in the required code and the correct details are displayed on a card.
However, I'm using a button on the customer information form to run the report (using a macro). What I want to do is use the form to view a particular customer's record and then click the button and the parameter value is set automatically the report is run and a card is created for the member who's record is displayed in the form.

Is there a way to get this to work, or are there any other methods ?????

Thanks for your help !!

 

[Rich]

Set criteria to =Forms!YourFormName!YourIDField
"Solutions" sample database has examples of how to do this.
HTH

 

[randypuppy]

Thanks very much - Now it works perfectly !!!!!!