form won't open in datasheet view.

[Skip Bisconer]

I am opening a form form an option control and the form is suppose to open in datasheet view but will not. I need the orginating opton form to go away while I viewing this linked spreadsheet table.
The form properites have all but Datasheet View as no and its set as Modal as help tells me to do, but to no avail. It opens in single form view.

Also when the originating option form comes back it is back at the forces settings I have for the opening form.

Would some one advise me on this issue? Thanks for looking.

Case 1
Me.Visible = False
stDocName = "CurrentChargesBisconer"
Me.Visible = False
DoCmd.OpenForm stDocName, acNormal, , , , acDialog
DoCmd.MoveSize 500, 2000, 18000, 8650
DoCmd.Restore
Me.Visible = True

 

[RuralGuy]

DoCmd.OpenForm stDocName, acFormDS, , , , acDialog

 

[Skip Bisconer]

Thanks RG, you saved me again.

 

[RuralGuy]

Glad I could help.