close form without required field msg box

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

deb - 31 Jul 2007 17:58 GMT

How can I close a form with required fields without the msg box popping up
to enter required fields.
I do not want the user to have to hit the escape button. I want the form to
close without msgs.

Signature

deb

Reply to this Message

Jeff Boyce - 31 Jul 2007 18:22 GMT

Deb

How will Access "know" when it is OK to NOT require fields, or when it MUST
require fields? Maybe you don't need required fields?

Regards

Jeff Boyce
Microsoft Office/Access MVP

> How can I close a form with required fields without the msg box popping up
> to enter required fields.
> I do not want the user to have to hit the escape button. I want the form
> to
> close without msgs.

Reply to this Message

deb - 31 Jul 2007 18:32 GMT

If the user closes the form without filling in the required fields, the
record will be deleted. This is working. however it displays the required
field msg box before deleting the record and closing the form.

Signature

deb

> Deb
>
[quoted text clipped - 11 lines]
> > to
> > close without msgs.

Reply to this Message

Jeff Boyce - 31 Jul 2007 18:39 GMT

It sounds like your user could close the form one time and get his/her work
deleted and close it another time and get it saved. How do they know what's
happening?

Regards

Jeff Boyce
Microsoft Office/Access MVP

> If the user closes the form without filling in the required fields, the
> record will be deleted. This is working. however it displays the required
[quoted text clipped - 18 lines]
>> > to
>> > close without msgs.

Reply to this Message

UpRider - 31 Jul 2007 18:43 GMT

Deb, in the property sheet change the required=yes to required=no for all
fields in question.
In the form_close event, have your code check each textbox that was formerly
'required'. If any are null, delete the record.
If all are OK, save the record.

HTH, UpRider

Reply to this Message