Forms with Reports

CodeCracker0291

Registered User.
Local time
Today, 14:59
Joined
Jan 19, 2002
Messages
33
I basically have a Form that you enter investment info in and then I have a print report command button on the form. Well now if I enter in more than one record in my form and i go to print it or prieview it it brings up all the reports. How can i make it only make a report and print it only of the one that is showed when the button is clicked? Thank You, CodeCracker0291
 
The criteria some key field in the recordsource of the report should be modified accordingly.
 
How?

How exactly do I do that?
 
docmd.openreport "rptYourReportName",,,"[ID]=" & me!ID

where your report has the same recordsource as your form and ID is the unique identifier of the investment info (record) displayed on your form.
 
hii
i uploaded u an example follow it

just make qury and put under name [forms]![formname]![filedname]
and make a command putton to print the report which is have data source from the query which yuou did. enjoy
 

Attachments

Users who are viewing this thread

Back
Top Bottom