OnClose Event Macro Action error

[Sarah.M]

Hi, Plz note, My VBA is blocked by IT for security reason (Cybersecurity).
I can use only Expression builder, Macros, Queries, Tables, Forms and Reports only.
----------------------------------------------------------------------------
If the user want to close the frmPhone Form
if he click Yes, (Save and Requery the frmUsers Form)
If he Click No, (if the form is empty, do nothing just close frmPhone form), but if there is some data written he show Clear the data and do no save it and do not requery the main form, I try the following way but I got this error attached in the picture below
plz help me
Sample Attached

 

[pbaldy]

I don't use macros, but try testing the Dirty property of the form. This worked in a test:

 

[arnelgp]

use OnUnload method of the form.
on the OnClose Event, all the controls are already destroyed.

 

[Sarah.M]

use OnUnload method of the form.
on the OnClose Event, all the controls are already destroyed.

Hi, I tried but still not working, please see OnUnload Event on the attached form

 

[arnelgp]

it's a kinda, very hard.
since the record will be saved before it goes to the Unload/Close event of the form.
you can't use BeforeUpdate since you need to also test if the form is closing?

there is a simple solution, add a Notice whenever you are creating New record.

 

[Sarah.M]

it's a kinda, very hard.
since the record will be saved before it goes to the Unload/Close event of the form.
you can't use BeforeUpdate since you need to also test if the form is closing?

I put it in BeforeUpdate still nothing happen

there is a simple solution, add a Notice whenever you are creating New record.

Can you please explain this idea to me?