Default open View changes when opened from VBA

[Tuckejam]

Ok I have a couple of general maintenance forms that when opened from the object browser menu (the menu on the left side of access) The forms open in Datasheet View, not flashy but its how I want them to open

But I am creating a menu with buttons to open these forms. and when I use the on click DoCmd.OpenForm "frm_TransType" the form opens in form view.

even after changing all the properties of the form

Default View - Datasheet


Allow Form View - No
Allow Datasheet View - Yes
Allow Layout View - No

it still always opens in form view when using the vba coded button

thanks

[Missinglinq]

That's the Default View when using the syntax

DoCmd.OpenForm

To get it to open in Datatsheet View, use with this parameter

DoCmd.OpenForm "frm_TransType", acFormDS

Linq ;0)>