New record test?

[Craig Buchanan]

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

 

[Jeff Boyce]

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>

 

[Craig Buchanan]

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 Buchanan]

scratch that.

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