[AccessD] Dirty property

[Bill Benson]

I believe he meant bound controls...

Me.Dirty is false until a bound control changes, is until the record is
committed unless Escape is pressed, which undoes all unsaved changes (and
makes the form's dirty property false again).

Easy to test this without closing the form, just open the VBE to the right
(or left) of you MS Access UI window, enter this in the VBE, and test at
various points.

?screen.ActiveForm.dirty

On Wed, Jul 22, 2015 at 3:11 PM, Susan Harkins <ssharkins at gmail.com> wrote:

> Form uses a query.
>
> Susan H.
>
> On Wed, Jul 22, 2015 at 2:43 PM, Jim Dettman <jimdettman at verizon.net>
> wrote:
>
> > 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
> >
> > --
> > 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
>