How to code dirty event of subform

[Amin]

Hi,

Longtime ago I read answer of Alber Kallal... About
Recognising Dirty event of subform in mainform current
Event.. some how I miss placed print..

Subform is in mainform.. now in current event of subform
I want to recognise if at all subform has become dirty.

how can I code this in VBA..

Thanks in advance...
amin

 

[Albert D. Kallal]

I likey suggested that you create a module level var in the main form.

dim bolSubFormDirty as boolean

You then create a function in the main form called:

Public Function SetMyDirty

bolSubFormDitry = True

end if


Then, in the sub-forms after update event, you go:

me.Parent.SetMyDirty


The above should do the trick, and then

if bolSubFormDitry = True then
' sub for is dirty...

 

[Amin]

Hi,
Many thanks Albert for the reply..
Amin