Form Event Property - Insert New Record

[iain]

Is there a Form Event Property that can be used to detect if the user clicks
on the Insert New Record Navigation Button?

 

[John Spencer]

Use the current event of the form and test the new record property.

That won't tell you if the user pressed the navigation button. As far as I
know there is no way to detect that.

You could build your own navigation buttons and then you would be able to
detect the click.

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County

 

[Mr. B]

iain,

Yes, you can use the "On Current" event of your form.

You can use code like:

If Me.NewRecord = True Then
MsgBox "This is a new Record!"
End If

Just replace the "Msgbox" with what ever you want to have happen.

-----
HTH
Mr. B
http://www.askdoctoraccess.com/
Doctor Access Downloads Page:
http://www.askdoctoraccess.com/DownloadPage.htm

 

[iain]

Thanks

iain,

Yes, you can use the "On Current" event of your form.

You can use code like:

If Me.NewRecord = True Then
MsgBox "This is a new Record!"
End If

Just replace the "Msgbox" with what ever you want to have happen.

-----
HTH
Mr. B
http://www.askdoctoraccess.com/
Doctor Access Downloads Page:
http://www.askdoctoraccess.com/DownloadPage.htm

 

[iain]

John,

Thank you.

Slightly confused by your first line. Are you saying that Mr B's response
won't work?

 

[Rick Brandt]

John,

Slightly confused by your first line. Are you saying that Mr B's
response won't work?

Since what the two said are almost identical how could you arrive at that
inference?

John was simply pointing out that the method tells you that the user
navigated to the new record position, but it cannot determine if they
used the >* navigation button to get there (which is what you asked).

There are numerous ways to arrive at the new record position without
using the "Insert New Record Navigation Button". Do you only care that
they got to that position or do you care that they used that specific
button to get there?