Cust Report off Form

spalmateer

Registered User.
Local time
Today, 14:53
Joined
Dec 5, 2000
Messages
46
Hello,
I have a form that is based off a parameter query that allows the user to enter a customers last name to find the record. When the customer record is pulled up on the form I would like the user to be able to press a command button that prints a report off the currently displayed customer. How do I set the record source of the report to be the same as the form. Would I link them through customer number. I honestly don't know where to begin. Thanks for any help!
Scott
 
Hy Scott, You can use a query (the same used for the form) including in Customer field parameter row:
[Customer] = Forms![YourFormName]![CustomerControlName]
It will be works (pay attention: when report will be opened form must be opend too).
Bye, S.
 

Users who are viewing this thread

Back
Top Bottom