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