Allow Additions=No in form

[tucker61]

I have 2 buttons on my switchboard to open the same form, 1 in Form view, the 2nd in Datasheet view,
In form view I have custom buttons to add new records, with the code on the button me.allowadditions = true.
This works for me in form view, however when users want to use the datasheet view they cannot add new records.

Can i set allow additions to no, for the form view and to yes for the datasheet view?

 

[SOS]

1. I hate the built in switchboard as I find it too limiting.

2. If I was opening my form I would use my own code:

For the Single Form View:
DoCmd.OpenForm "MyFormNameHere", acViewNormal
Forms!MyFormNameHere.AllowAdditions = False

For the Datasheet View:
DoCmd.OpenForm "MyFormNameHere", acFormDS
Forms!MyFormNameHere.AllowAdditions = True

 

[tucker61]

Thanks, makes sense, I will try tomorrow.

Regards
tucker61

 

[SOS]

And actually if you set the AllowAdditions to False as a default then you only have to do the extra code in one of the places