When opening the form via code, use:
DoCmd.OpenForm "Form1", acFormDS

Signature
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
> I have a form in data sheet view that I am trying to open from a
> switchboard. So while opening the firm directly opens it in data sheet
[quoted text clipped - 4 lines]
>
> Thanks.