How to code dirty event of subform

  • Thread starter Thread starter Amin
  • Start date Start date
A

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
 
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...
 
Back
Top