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)
 
Back
Top