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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
WxBug said:
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]
Click to expand...

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.
 
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.
Click to expand...

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.....
 
Albert said:
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.....
Click to expand...

I had my magnifiers on ;-)
 
Back
Top