Conditional Message Box

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Sharon123 - 22 May 2008 19:57 GMT

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.

Reply to this Message

strive4peace - 23 May 2008 02:50 GMT

Hi Sharon,

do these dates need to be filled before a record is saved?

Warm Regards,
Crystal

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

*
(: have an awesome day :)
*

> Hi,
> I have a form that when I click on the close button would like for it to
[quoted text clipped - 3 lines]
> keep getting an error.
> Thanks in advance for anyone who can help.

Reply to this Message

Jason - 23 May 2008 09:20 GMT

if so then in the table specify required as YES

> Hi Sharon,
>
[quoted text clipped - 18 lines]
> > keep getting an error.
> > Thanks in advance for anyone who can help.

Reply to this Message

strive4peace - 23 May 2008 16:06 GMT

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 :)
*

> if so then in the table specify required as YES
>> Hi Sharon,
[quoted text clipped - 22 lines]
>>> keep getting an error.
>>> Thanks in advance for anyone who can help.

Reply to this Message