Opening Forms in Datasheet view via VBA

[RandomNeeds]

I have read various answers on how to open a form in Datasheet view from VBA code, but I can't get my syntax correct. Please help?


Here is one of my 50 attempts to guess at the format. Removing different components, separators, variables only gets me a syntax error of missing separator or "expected =".



DoCmd.OpenForm ("frm_OrdersHOTHeadersOnlyWORKSHEET", [View as acFormView=acFormDS], , , , ,[acFormEdit])
:banghead:

 

[Fran Lombard]

DoCmd.OpenForm "frm_OrdersHOTHeadersOnlyWORKSHEET", acFormDS, , , acFormEdit

 

[RandomNeeds]

That worked! Bingo!

Thank you!!!!!

 

[Fran Lombard]

Glad to help - Remember to use the F1 Key