bobbster2000
Programmer
I have a Report with 35 records. But unfortunately, when I want to print just one of them, I get all 35 of them. Can somebody please tell me how to print any record I want to print instead of all of them?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Print current record 1
- Thread starter bobbster2000
- Start date
- Status
-
1
- #2
LonnieJohnson
Programmer
In your query that feeds your report (if you don't have a query, build one) put a parm in one of the criteria fields that would select the record you want.
For instance, if you want a certain employee ID, then in the EmployeeId field you would put [What is the ID] as the criteria. By having this in brackets then you will get a prompt for the value when you open the report. You can put in the value and get the desired record. ljprodev@yahoo.com
ProDev, MS Access Applications B-)
For instance, if you want a certain employee ID, then in the EmployeeId field you would put [What is the ID] as the criteria. By having this in brackets then you will get a prompt for the value when you open the report. You can put in the value and get the desired record. ljprodev@yahoo.com
ProDev, MS Access Applications B-)
- Status
Similar threads
- Locked
- Question
- Locked
- Question