Conditional Message Box

  • Thread starter Sharon123 via AccessMonster.com
  • Start date
S

Sharon123 via AccessMonster.com

Hi,
I have a form that when I click on the close button would like for it to
check the data in the Subform and make sure that the Date fields are not null,
if it is I would like a message box to pop up and say "Please fill in the
date", I am not sure if its possible to do it with a subform. I tried it but
keep getting an error.
Thanks in advance for anyone who can help.
 
S

strive4peace

actually, I was going to suggest a form BeforeUpdate event if the dates
are required... then the changes to the record can be CANCELled if the
user chooses to dump the changes (either the new record or edits to an
existing record)

Warm Regards,
Crystal

Access Basics
8-part free tutorial that covers essentials in Access
http://www.AccessMVP.com/strive4peace

*
:) have an awesome day :)
*
 
Top