[AccessD] Dirty property

[Susan Harkins]

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
>