I
iain
Is there a Form Event Property that can be used to detect if the user clicks
on the Insert New Record Navigation Button?
on the Insert New Record Navigation Button?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
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
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
M
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
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
I
iain
Thanks
Mr. B said: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
I
iain
John,
Thank you.
Slightly confused by your first line. Are you saying that Mr B's response
won't work?
Thank you.
Slightly confused by your first line. Are you saying that Mr B's response
won't work?
R
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?