Printer dialog when printing a record

BadSikander

Registered User.
Local time
Today, 23:06
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.
 

Users who are viewing this thread

Back
Top Bottom