Allow Additions Ignored

  • Thread starter Thread starter Andy
  • Start date Start date
A

Andy

Access 2003.

I have a form based on a table and in the Properties (Data Tab), I have set
Allow Additions to No. However, when I open the form, I can navigate to a new
record and the navigation buttons do not have the New Record button greyed
out.

Any help appreciated.
 
Are you using DataSheet view for the form? Is there any code running in the
form's Open, Load, and/or Current event?
 
Figured this one out.

I opened the form with DataMode:=acFormAdd which seems to have overwritten
the Allow Additions = No property.

Thanks for help Ken.
 
Andy said:
Figured this one out.

I opened the form with DataMode:=acFormAdd which seems to have overwritten
the Allow Additions = No property.
Click to expand...

Yes, the DoCmd action's arguments will override the property settings for
the form/report that you're opening.
 
Back
Top