Tech Support Guy banner
Status
Not open for further replies.
1 - 2 of 2 Posts

·
Registered
Joined
·
10 Posts
Discussion Starter · #1 ·
How do I choose just 1 record for a report that will be printed out? In my case, I want to print a list of phone numbers that a client is allowed to call. The client's name is in the first table and the phone numbers are in another table.
Thanks:)
 

·
Registered
Joined
·
680 Posts
Ok in the criteria field of the query that feeds the data to the report you need this in the id

forms![formname]![Controlname]

formname being the actual name of your form and controlname being the name of your id field.

you will also need a button on the form, with the below code attached

DoCmd.OpenReport "YourReportName", AcViewPreview

YourReportName being the actual name of your report

Hope this helps you.
 
1 - 2 of 2 Posts
Status
Not open for further replies.
Top