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.
 

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

Preventing Record Update 3
Adding Records to Sub-Form by Default 3
How to detect navigation 5
Inconsistent Add Record Performance 1
Append Records from a subform to a new record 1
SubForm does not accept focus when adding a new record ? 4
Prevent Moving to New Record vs two Forms? 9
Add new record to master and subform at the same time. 16

Back
Top