Because of the fact that
- The AllowAdditions Property is set to No
- But the Access Gnomes are still allowing A New Record to be initiated
my guess would be that the Form in question is being Opened using code similar to
DoCmd.OpenForm "ContinuousFormName", , , , acFormEdit
or the Macro equivelent, thinking that the acFormEdit argument would only allow the editing of Records. The problem with this assumption is two-fold:
- acFormEdit allows for the Editing of Existing Records and the Adding of New Records
- acFormEdit tells Access to ignore the AllowAdditions and AllowEdits Properties of the Form being Opened as set in that Form's Properties Pane!
To allow the AllowAdditions and AllowEdits Properties of the Form being Opened to act as set in the Properties Pane, i.e.
- AllowAdditions set to No
- AllowEdits set to No
you need to Open the Form with code like this
DoCmd.OpenForm "ContinuousFormName", , , , acFormPropertySettings
The acFormPropertySettings argument tells Access to respect the Form's Properties as set in the Properties Pane.
Sorry, but I have no idea how to accomplish this using a Macro, or even if it can be accomplished using a Macro! That's one of the problems with Macros, they're too limited/rigid in what they can and cannot do, which is why most experienced Access developers do not use them!
Linq ;0)>
The problem with making anything foolproof...is that fools are so darn ingenious!
All posts/responses based on Access 2003/2007