Dirty Subform

Is this the way to determine if a subform is dirty?

If Me!SFrmEnterActivityList.Form.Dirty Then

I use this statement in the Unload event of a form. When I click the Close
button, the statement is always false whether I have made a change in the
subform or not.

Thanks!

Mark

re: Dirty Subform

"Mark" <mmorrow@earthlink.net> wrote in message
news:Ue%Nb.10303$q4.9834@newsread3.news.atl.earthl ink.net...[color=blue]
> Is this the way to determine if a subform is dirty?
>
> If Me!SFrmEnterActivityList.Form.Dirty Then
>
> I use this statement in the Unload event of a form. When I click the Close
> button, the statement is always false whether I have made a change in the
> subform or not.
>
> Thanks!
>
> Mark
>
>[/color]

re: Dirty Subform

If you are executing code on the form, chances are your focus has left the
subform.
Whenever your focus leaves the subform, the data in the subform is saved,
and its Dirty property becomes false.

HTH
- Turtle

"Mark" <mmorrow@earthlink.net> wrote in message
news:Ue%Nb.10303$q4.9834@newsread3.news.atl.earthl ink.net...[color=blue]
> Is this the way to determine if a subform is dirty?
>
> If Me!SFrmEnterActivityList.Form.Dirty Then
>
> I use this statement in the Unload event of a form. When I click the Close
> button, the statement is always false whether I have made a change in the
> subform or not.
>
> Thanks!
>
> Mark
>
>[/color]

re: Dirty Subform

Yes!! That's exactly what is happening. Thanks for pointing it out.

Mark


"MacDermott" <macdermott@nospam.com> wrote in message
news:zh%Nb.10308$q4.2566@newsread3.news.atl.earthl ink.net...[color=blue]
> If you are executing code on the form, chances are your focus has left the
> subform.
> Whenever your focus leaves the subform, the data in the subform is saved,
> and its Dirty property becomes false.
>
> HTH
> - Turtle
>
> "Mark" <mmorrow@earthlink.net> wrote in message
> news:Ue%Nb.10303$q4.9834@newsread3.news.atl.earthl ink.net...[color=green]
> > Is this the way to determine if a subform is dirty?
> >
> > If Me!SFrmEnterActivityList.Form.Dirty Then
> >
> > I use this statement in the Unload event of a form. When I click the Close
> > button, the statement is always false whether I have made a change in the
> > subform or not.
> >
> > Thanks!
> >
> > Mark
> >
> >[/color]
>
>[/color]