Open form on update of field in another form.

[thekruser]

What I have:
frmDataEntry
-txtTrainingCompleteDate

frmTrainingVerify (only has text and close button)

What I am trying to do:
I am trying to get frmTrainingVerify to open when txtTrainingCompleteDate is updated. It is basically just a popup telling the user to verify the information he/she just entered and to remind them that this action requires another action by them.

The problem:
I am not sure how to procede. I think I need to add an AfterUpdate event procedure, but I cannot figure out the VBA code to get it done (I know NOTHING about VBA).

Thank you in advance for your time and help.

[pbaldy]

I would probably just use a message box instead of a form, but the code to open it would be:

DoCmd.OpenForm "frmTrainingVerify"

Here's how to get it into the event code:

http://www.baldyweb.com/FirstVBA.htm

[thekruser]

Oh...even better. How do I do a message box? That would be PERFECT!!

[pbaldy]

Look at MsgBox in VBA help for all the options. At its simplest:

MsgBox "Your text here"

[thekruser]

It worked perfectly. Thank you for your help!!

[pbaldy]

No problemo!