Allow Additions Ignored

[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.

 

[Ken Snell \(MVP\)]

Are you using DataSheet view for the form? Is there any code running in the
form's Open, Load, and/or Current event?

 

[Andy]

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.

 

[Ken Snell \(MVP\)]

Figured this one out.

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

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