If Then for on Form Close

  • Thread starter Angelsnecropolis
  • Start date
A

Angelsnecropolis

I have a form that displays a MSGBox beforeupdate when specific fields are
null. If these fields haven't been touched then the form closes like normal.
After the fields have been maintain

I'd like to be able to add an If...then statement so on form close don't
display msgbox.
 
A

Allen Browne

Form_Close occurs *after* Form_BeforeUpdate, so you can't avoid the message
like that.

Perhaps you could add a button to cancel'n'close:
If Me.Dirty Then Me.Undo
DoCmd.Close acForm, Me.Name

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

message
news:[email protected]...
 
A

Angelsnecropolis

Thank you Mr. Browne.

Allen Browne said:
Form_Close occurs *after* Form_BeforeUpdate, so you can't avoid the message
like that.

Perhaps you could add a button to cancel'n'close:
If Me.Dirty Then Me.Undo
DoCmd.Close acForm, Me.Name

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

message
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Making a macro only work on certain files 2
How do I clear a form? 0
Word Template where user inputs <TITLE> and then that can be displayed in footers or headers [MAC] 0
Cancel BeforeUpdate Subf on Form Close 0
Creating a Search using a combo box and then creating a report. 4
Testing for required data entry in form fields. 6
Clearing Fields in a Word Form 5
Dynamic Naming of Form Button 3

Top