Command Button Problems

[margt_a]

I have a command button that is supposed to open a form in datasheet view and show a list of records... nothing complicated. The problem is that the form will only open in form view. I have even set the form so that only datasheet view is allowed. If I open the form directly, without using the command button, it opens in datasheet view.

Any Ideas?
Thanks!
Margaret

 

[chrismcbride]

I never use the Datasheet view, but this seems to work...

DoCmd.OpenForm "frmYourFormName", acFormDS

HTH
Chris

 

[margt_a]

The code bit worked! Thank you,
Margaret

 

[chrismcbride]

A pleasure...