[AccessD] Dirty property

[Susan Harkins]

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
>