New record test?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Craig Buchanan - 19 Jul 2005 19:48 GMT

is there a reliable way to test if a form has been moved to a new record (as
opposed to changing to another, existing record)?

thanks

craig buchanan

Reply to this Message

Jeff Boyce - 19 Jul 2005 20:12 GMT

Craig

Not sure I understand how you mean "moved to a new record", but I suspect
you can check the

Me.NewRecord

property.

Good luck

Jeff Boyce
<Access MVP>

> is there a reliable way to test if a form has been moved to a new record (as
> opposed to changing to another, existing record)?
>
> thanks
>
> craig buchanan

Reply to this Message

Craig Buchanan - 19 Jul 2005 20:41 GMT

Jeff-

Thanks, just what I needed. I've notice that this works when you click the
new record button on the form's navigation bar. I appears not to work if
you open a form with the acFormAdd bit set. Is there another property to
check for this?

Thanks,

Craig

> Craig
>
[quoted text clipped - 17 lines]
> >
> > craig buchanan

Reply to this Message

Craig Buchanan - 19 Jul 2005 20:47 GMT

scratch that.

> Jeff-
>
[quoted text clipped - 28 lines]
> > >
> > > craig buchanan

Reply to this Message