Prevent adding new record

  • Thread starter Thread starter paul
  • Start date Start date
P

paul

TGIF,
For Access 2000 application, I have a main data entry
form, with a subform. In order to add new record, the user
need to click the custom "New" button (I disable the page
up and down key to prevent users add new records). But
once in a while, I still found new records from the
subform. How to stop it? Thanks a lot.
 
Paul,

The best way is to toggle the form's AllowAdditions property
to True or False as needed.

Gary Miller
Sisters, OR
 
How to stop it?
Click to expand...

Set the AllowAdditions property of the subform to True. This will
prohibit you from navigating to the new record in your code; you may
have to toggle the property on and off.
 
Back
Top