New record detection

  • Thread starter Thread starter malcolm
  • Start date Start date
M

malcolm

When a user clicks the next record button in the
navigation bar and moves past the end of file a new
record is created. How can I detect this and display a
message box asking whether the user wants a new record
created. If not then I want to be able to cancel the new
record. The BeforeInsert event only fires if the user
enters a character in the new record.
 
Test the NewRecord property of the form in its Current event.

If you just want a display on the form, set the ControlSource of a text box
to:
=IIf([Form].[NewRecord],"New Record",Null)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need combo box to refresh when moving to new record 2017 1
How to detect navigation 5
Cancel record navigation? 2
Uninserted Record cont 7
Need help with Form objects 0
Access Automatically Send a notification email once a record is added 0
Form validation and deleting record if dirty 2
Unlock text box for new record entry 5

Back
Top