Would like to know if there is a way to have a command button on a (multi Table ) one form that will print a report of current data that was entered. I currently have a command to open report run off a query with parameter value windows. That too many steps would like simplify it.
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 SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Print command button on form 1
- Thread starter MIKERYAN
- Start date
-
1
- #2
Use the OpenReport method of the DoCmd command. For example<br><br> stDocName = "Your reportName"<br> stAccount = "[Field1] = Forms!frmName!Field1"<br> DoCmd.OpenReport stDocName, acPreview, stAccount<br><br><br>This will open the report from your form, using the criteria you set in the variable stAccount (or whatever you name it).<br><br>Lightning<br>
Guest_imported
New member
- Jan 1, 1970
- 0
- 0
- 0
Thank you Lightning I will give that a try.
- Status
Similar threads
- Locked
- Question
