[AccessD] Dirty property

[Steve Schapel]

Hi Susan

"The code behind that event uses Me.Dirty to check for any new values."

What event are you referring to?  Do you have a command button on the form, 
and you are looking at the Click event of the button?  Or do you mean the 
form's built-in [x] close button, and you are looking at the form's Close 
event?  Or something else?

Regards
Steve

-----Original Message----- 
From: Susan Harkins
Sent: Thursday, July 23, 2015 6:18 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Dirty property

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