Christian, Lorraine
LChristian at MassMutual.com
Wed Dec 22 11:41:42 CST 2004
I am so sorry about the first message....forgot to unsecure it....
I hate our email system...sorry again.
Hi there and Happy Holidays :)
I have a form that can be printed by clicking a print command button.
My problem is that when the client clicks the button, the form prints
as expected however it goes to a new record. I want it to stay
on the record that was printed. Below is the code behind my button.
Private Sub cmdPrint_Click()
DoCmd.SetWarnings False
DoCmd.RunCommand acCmdSaveRecord
DoCmd.GoToControl "[txtClaimNumber]"
DoCmd.RunCommand acCmdFilterBySelection
DoCmd.PrintOut acSelection, , , acHigh, 3, True
DoCmd.RunCommand acCmdRemoveFilterSort
DoCmd.SetWarnings True
End Sub
Any ideas?
Lorraine Christian
MassMutual Financial Group
New Business Operations
413.744.5335
lchristian at massmutual.com
---------------------------------------------------------
This e-mail transmission may contain information that is proprietary, privileged and/or confidential and is intended exclusively for the person(s) to whom it is addressed. Any use, copying, retention or disclosure by any person other than the intended recipient or the intended recipient's designees is strictly prohibited. If you are not the intended recipient or their designee, please notify the sender immediately by return e-mail and delete all copies.
---------------------------------------------------------