Code to open form in design view and then back in datasheet view

[mlunter]

Hello everyone and thank you for all the useful information,

I have a form that is setup to be in datasheet view. I want the information to look just like a query except I am blocking a few things from being edited. I set up the form, and when I link to it from another form it opens it up in regular form view. I have to hit design view, then normal view again in order to get the datasheet view I am looking for.

I have tried editing various properties such as disallowing form view, pivot table view, etc. and allowing datasheet view only. I also tried working code and using functions like AllowDatasheetView , but with no success. I even tried using a macro, but I couldn't get it to work. Any suggestions would be appreciated.

Thank you!

 

[RoyVidar]

In the code opening this form, be sure the the second arguement is acFormDS

[tt]docmd.openform "thisform", acFormDs, ...[/tt]

Roy-Vidar

 

[stevedi]

try

for the button or what ever your using to open the next form;

DoCmd.OpenForm "next_form", acFormDS

Steve

 

[stevedi]

Oops I misunderstood which form. Roy-VIDAR has it.

 

[mlunter]

I'm sorry, but I am pretty weak with VBA (but improving). This is what I put and it didn't work:
--------------------------------------------------
Private Sub Form_Open(Cancel As Integer)

docmd.openform frmEditMonthlyForecastDataQueryView, acFormDs,

End Sub
-------------------------------------------------

I am certainly starring you guys, but more help would be appreciated.

 

[RoyVidar]

In the code opening this form, means the existing code - the code which now opens the form, but having a wrong second arguement (or none). You will find that code behind the existing button somewhere on the form which calls this one. Btw - the form name goes in "quotes". The cod you have now placed in a forms on open event, must be removed.

Roy-Vidar