Why Is a New Record available On Forms With AllowAdditions=No

[WxBug]

Using Access 2003, with the database currently in Access 2000 format...

I have a form with properties set as follows: AllowEdits = Yes,
AllowDeletions = No, AllowAdditions = No. The form is intended to list only
open work orders. The form opens using a Macro with the OpenForm "Where
Condition" set to select Field Name "Closed" (a Yes/No field) set to "No."
When the form opens, it accurately has all the records that meet the Where
Condition. However, using the mouse wheel (or navigation buttons), I can
scroll through the entire set of records and, at the end of the set, activate
a NewRecord.

A query (where the returned records are editable) on the same table with the
same "Condition" produces the same result, a set of records meeting the
condition, plus the NewRecord.

Bottom line: What I wish to do is have a form where the records meet the
condition viewable on the form (form view or datasheet view) without a
NewRecord possible/viewable, and each record displayed to be editable.

Any help on this subject will be greatly appreciated.

Richard

 

[Rick Brandt]

Using Access 2003, with the database currently in Access 2000 format...

I have a form with properties set as follows: AllowEdits = Yes,
AllowDeletions = No, AllowAdditions = No. The form is intended to list only
open work orders. The form opens using a Macro with the OpenForm "Where
Condition" set to select Field Name "Closed" (a Yes/No field) set to "No."
When the form opens, it accurately has all the records that meet the Where
Condition. However, using the mouse wheel (or navigation buttons), I can
scroll through the entire set of records and, at the end of the set, activate
a NewRecord. [snip]

Look at the bottom of your macro at the Data Mode. If that is set to Edit then
it will override the default settings of the form for AllowAdditions.

 

[Albert D.Kallal]

Look at the bottom of your macro at the Data Mode. If that is set to Edit

then it will override the default settings of the form for AllowAdditions.

gee, Mr. Eagle eyes....good catch on your part.

I did not know that macros over ride the forms setup. Probably another great
reason to avoid macros!!

I would never have guessed this answer.....

 

[Rick Brandt]

gee, Mr. Eagle eyes....good catch on your part.

I did not know that macros over ride the forms setup. Probably
another great reason to avoid macros!!

I would never have guessed this answer.....

I had my magnifiers on ;-)