Prevent adding new record

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.
 
G

Gary Miller

Paul,

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

Gary Miller
Sisters, OR
 
J

John Vinson

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.
 
Top