MS Access form called from a Access menu will not open in Datasheet view. (1 Viewer)

[Regger]

Hi ,

I am new to the forum and posting a problem I have been dealing with for the last few days. Your insights would be appreciated.

If I open my access forms directly they open in datasheet view. If I open same forms from a forms menu I created using click on Buttons they will not open in datasheet view. They do open in a different view and still function just not datasheet view. I have set the Form Properties for each as in below attachment , Default View is Datasheet, and when that did not work I modified the Form and Layout views to "no". Even with these settings the forms still will not come up in Datasheet view when one presses the Button on the menu. These same forms clicked directly go to Datasheet view. Any idea Why and how to correct? I am using Access 2016. Thanks

 

[isladogs]

You didn't say what code you are using to open the form
Try specifying datasheet view:

DoCmd.OpenForm "YourFormName",acFormDS

 

[Regger]

isladogs, Thank you your recommendation worked!

 

[isladogs]

That's great. Welcome to the forum!