Was anything changed on my Form ?

[ECEK]

I have my form with sub forms and wondered if there was a quick fix to see if anything has been changed (on either the main form or sub forms)

The reason for this is that I want to create a MsgBox that states "You haven't submitted any changes"

I have tried "On Data Change" but this doesn't register changes on sub Forms.

Any help is always immensely appreciated

 

[Ranman256]

You'd need a "On Data Change" in both forms.

 

[ECEK]

Thanks RanMan
I started to go down that route but I'm struggling to reference the cmdbutton on the parent form.

Basically

if a change in SubForm1 Then
ParentForm.CmdNextButton.visible = TRUE

 

[Gasman]

Me.Parent.cmdbutton

 

[ECEK]

Thanks Gasman
I can get that to work on the OnChange of the specific Fields within my SubForm but it doesn't work on the SubForm's On Data Change event !!

 

[Gasman]

Thanks Gasman
I can get that to work on the OnChange of the specific Fields within my SubForm but it doesn't work on the SubForm's On Data Change event !!

Way beyond my skill level.

https://msdn.microsoft.com/en-us/library/office/jj249049.aspx

The On Data Change mentioned pivot tables and only certain events.?


Perhaps you could try a public variable set to false on Load/Current and set to true in the AfterUpdateEvent?
All I can suggest, sorry

 

[isladogs]

How about a different approach.
Have a Boolean field E.g. ChangeFlag which will by default be false.
If any changes are made, set the value True.

When the value is checked, if its false show your message, otherwise reset the value to False

 

[Gasman]

How about a different approach.
Have a Boolean field E.g. ChangeFlag which will by default be false.
If any changes are made, set the value True.

When the value is checked, if its false show your message, otherwise reset the value to False

Yes , I was thinking along the correct lines.