Thank you, CautionMP
I created a form "MyMessage", added a label to hold my message. Then put the following after update code in the invamt field.
if me.invamt >= 5000 then
docmd.openform "MyMessage"
end if
On the form "MyMessage" I put this code in the activate event:
DoCmd.DoMenuItem...
Hi PHV,
Thank you for replying to my post.
Sorry,I think my message was not clear. In my form I have this code in the after update events:
If me.invamt >= 5000.00 then msgbox "Approval Required".
It then pop up a message to remind the user.
I want to send this message to the printer. I...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.