By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,671 Members | 1,280 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,671 IT Pros & Developers. It's quick & easy.

new record detection

P: n/a
ken
Hi,
Is there anyway I could detect on a form when the "add new record
button" has been pressed?

Thanks

Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
When you move to a new record, the form's Current event will fire, and the
form's NewRecord property will be True.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"ken" <ge****@gmail.com> wrote in message
news:11**********************@o13g2000cwo.googlegr oups.com...

Is there anyway I could detect on a form when the "add new record
button" has been pressed?

Nov 13 '05 #2

P: n/a
ken wrote:
Hi,
Is there anyway I could detect on a form when the "add new record
button" has been pressed?

Thanks


You can use...

If Me.NewRecord = True Then...

In the Form's Current event to determine when the form has been positioned at
the new record position. This won't tell you if that was accomplished by
pressing the "Go To New Record" button in the navigation bar though.

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com
Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.