[AccessD] Dirty property

[Jim Dettman]

Susan,  

Couple things to watch out for:

1.  Doesn't work on unbound forms

2.  Record won't be dirty on a main / sub form setup if you have entered the subform control and made no changes since you did. Entering subform control commits the main record.

Jim

Sent from my iPhone

> On Jul 22, 2015, at 2:18 PM, Susan Harkins <ssharkins at gmail.com> wrote:
> 
> I open the form.
> I enter a value in a new record.
> I close the form via the Close button.
> The code behind that event uses Me.Dirty to check for any new values.
> Dirty is returning False.
> 
> Susan H.
> 
> On Wed, Jul 22, 2015 at 1:02 PM, Heenan, Lambert <Lambert.Heenan at aig.com>
> wrote:
> 
>> That's confirmed. Dirty=True as soon as any column is changed.
>> 
>> Lambert
>> 
>> 
>> 
>> -----Original Message-----
>> From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
>> Dan Waters
>> Sent: Wednesday, July 22, 2015 12:50 PM
>> To: 'Access Developers discussion and problem solving'
>> Subject: Re: [AccessD] Dirty property
>> 
>> Hi Susan,
>> 
>> I've been using Me.Dirty, where Me is a reference to the current form, not
>> a record.  So, I believe that if you open a form to create a new record,
>> from the time you start entering information until the new record is saved,
>> then the form's Dirty property will be True.
>> 
>> HTH!
>> Dan
>> 
>> -----Original Message-----
>> From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
>> Susan Harkins
>> Sent: Wednesday, July 22, 2015 11:29 AM
>> To: Access Developers discussion and problem solving
>> Subject: [AccessD] Dirty property
>> 
>> I think I just realized, for the first time, that the Dirty property
>> doesn't work with a new record. What I just read suggests that it checks
>> since the record was last saved. Well, a new record has never been saved,
>> so the Dirty property is useless for a new record. Is this correct?
>> 
>> Susan H.
>> --
>> AccessD mailing list
>> AccessD at databaseadvisors.com
>> http://databaseadvisors.com/mailman/listinfo/accessd
>> Website: http://www.databaseadvisors.com
>> 
>> --
>> AccessD mailing list
>> AccessD at databaseadvisors.com
>> http://databaseadvisors.com/mailman/listinfo/accessd
>> Website: http://www.databaseadvisors.com
>> 
>> --
>> AccessD mailing list
>> AccessD at databaseadvisors.com
>> http://databaseadvisors.com/mailman/listinfo/accessd
>> Website: http://www.databaseadvisors.com
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com