Prev: Create a bound class
Next: Create Table
From: Allen Browne on 9 Feb 2010 07:20
As you found, the Dirty event probably isn't reliable. From memory, the way
it behaves is not consistent between different versions of Access either.

It is possible to trigger the event like this:
Call Form_Dirty(False)

However, it's probable that Form_BeforeUpdate will serve you better.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.


"Rob Hofkens" <nospam> wrote in message
news:4b713989$0$22935$e4fe514c(a)news.xs4all.nl...
> Hi all :)
>
> For a certain situation I needed to use an unbound textbox to update a
> hidden bound textbox.
> This works ok but it seems that editing an unbound textbox doesn't trigger
> to the Form_Dirty event.
> Also updating the hidden bound textbox via VB code doesn't trigger the
> Form_Dirty event.
> Gladly I discovered that the Form_BeforeUpdate gets triggered before I
> move to the next record,
> so I could make a work arround to handle not having a Form_Dirty trigger
> event.
>
> I am just curious if there is something I am not aware off that might be
> done to trigger a Form_Dirty event.
>
> Thanks in advance.
>
> Rob.
>
>
From: Rob Hofkens on 11 Feb 2010 09:26
Allen, thanks for you answer :)

Rob.


"Allen Browne" <AllenBrowne(a)SeeSig.Invalid> schreef in bericht
news:%23M3hQJYqKHA.6064(a)TK2MSFTNGP02.phx.gbl...
> As you found, the Dirty event probably isn't reliable. From memory, the
> way it behaves is not consistent between different versions of Access
> either.
>
> It is possible to trigger the event like this:
> Call Form_Dirty(False)
>
> However, it's probable that Form_BeforeUpdate will serve you better.
>
> --
> Allen Browne - Microsoft MVP. Perth, Western Australia
> Tips for Access users - http://allenbrowne.com/tips.html
> Reply to group, rather than allenbrowne at mvps dot org.
>
>
> "Rob Hofkens" <nospam> wrote in message
> news:4b713989$0$22935$e4fe514c(a)news.xs4all.nl...
>> Hi all :)
>>
>> For a certain situation I needed to use an unbound textbox to update a
>> hidden bound textbox.
>> This works ok but it seems that editing an unbound textbox doesn't
>> trigger to the Form_Dirty event.
>> Also updating the hidden bound textbox via VB code doesn't trigger the
>> Form_Dirty event.
>> Gladly I discovered that the Form_BeforeUpdate gets triggered before I
>> move to the next record,
>> so I could make a work arround to handle not having a Form_Dirty trigger
>> event.
>>
>> I am just curious if there is something I am not aware off that might be
>> done to trigger a Form_Dirty event.
>>
>> Thanks in advance.
>>
>> Rob.
>>
>>


 | 
Pages: 1
Prev: Create a bound class
Next: Create Table