MS Access form when called from a Access menu will not open in Datasheet view. ,

Question

If I open my forms directly they open in datasheet view. If I open from the forms menu I created they will not open in datasheet view, why and how do I get the datasheet view when opened off the menu? I have set the form properties as in below attachment , Default View is Datasheet and when that did not work I modified the other Form and Layout views to "no". The forms still will not come up in Datasheet view off the menu, Why? I am using Access 2016.

Answer 1

Hi,

What is your "forms menu"? A real menu, a ribbon item, controls on a form...?
Which method do you use to open the forms from there?
If it is by VBA, i.e. OpenForm, then you have to explicitely state the desired view if it is not the default form view:

DoCmd.OpenForm "frmFoo", acFormDS

Servus
Karl
Access News
Access DevCon