BadSikander
Registered User.
- Local time
- Today, 21:36
- Joined
- Jan 19, 2007
- Messages
- 31
Hello.
Is there any way to have the printer dialog box appear when printing a record in form view?
If I print the whole form I get the dialog box using:
Dim stDocName As String
stDocName = "FORMNAME"
DoCmd.RunCommand acCmdPrint
But the standard code to print a single record doesn't:
DoCmd.DoMenuItem acFormBar, acEditMenu, 8, , acMenuVer70
DoCmd.PrintOut acSelection
Is there any way to combine the two bits of code, so I can still print the individual record, but get the printer dialog box?
Normally I do all printing through reports, but in this case it needs to be printing from a form.
Thanks for any help.
Is there any way to have the printer dialog box appear when printing a record in form view?
If I print the whole form I get the dialog box using:
Dim stDocName As String
stDocName = "FORMNAME"
DoCmd.RunCommand acCmdPrint
But the standard code to print a single record doesn't:
DoCmd.DoMenuItem acFormBar, acEditMenu, 8, , acMenuVer70
DoCmd.PrintOut acSelection
Is there any way to combine the two bits of code, so I can still print the individual record, but get the printer dialog box?
Normally I do all printing through reports, but in this case it needs to be printing from a form.
Thanks for any help.