Exit form - no update

R

Raddy

Registered User.

Local time

Today, 05:23

Joined

Apr 29, 2010

Messages

34

• May 12, 2010

• #1

I have a control in my form that says Exit, to return to a calling menu form.
I have a macro attached to this which states:
"Close, ,prompt"
If I have changed the data the control returns to the menu, and any changes I have made remain

How can I set up some code so Exit means "exit - no update"?

 

M

MStef

Registered User.

Local time

Today, 05:23

Joined

Oct 28, 2004

Messages

2,251

• May 12, 2010

• #2

Look at "DemoExitFormA2000.mdb" (attachment, zip).
Open Form1 and try to change something in the Form1,
(f1 or f2 field), and Exit form.

 

Attachments

• DemoExitFormA2000.zip

  15.1 KB · Views: 231

R

Raddy

Registered User.

Local time

Today, 05:23

Joined

Apr 29, 2010

Messages

34

• May 12, 2010

• #3

MStef
Thanks for that. I hop you will bear with me, but how do i exit this form to get your message "Are you sure you want to save this changes?" displayed.
I think I am missing something

Thanks

 

M

MStef

Registered User.

Local time

Today, 05:23

Joined

Oct 28, 2004

Messages

2,251

• May 12, 2010

• #4

Click on the square with sign X in the right upper corner, (in the form).

 

R

Raddy

Registered User.

Local time

Today, 05:23

Joined

Apr 29, 2010

Messages

34

• May 12, 2010

• #5

Mstef
Thanks

You can see how green I am with all this Access/Vba stuff