View from command button is not what has been set! 1

[CliffordTheRedDog]

I have been using Access2002 for about two months now so this may be obviaous to somone else.
I have created a "switchboard" using the command button Wizard, however when the form is used the default view which should be set to datasheet keeps on coming up in formview. i have even set the allow views to only allow data sheet view, but somewhere the setting is being overwritten, any help would be appreciated. If i access the form directly from access the view defaults correctly. the database is in access 2000 is this the reason?
TIA Cliff

 

[dhookom]

Your DoCmd.OpenForm line must explicitly set the view mode to the datasheet view.

DoCmd.OpenForm "frmYourForm", acFormDS

Duane
MS Access MVP
Find out how to get great answers faq219-2884.

 

[CliffordTheRedDog]

dhhokum
U should see my Grin. I have struggled with this for too long. It worked so well. I ammended as your suggestion and Hey Presto!!!

DoCmd.OpenForm stDocName, acFormDS, , stLinkCriteria

Thankyou
Cliff

 

[CliffordTheRedDog]

dhookum
dhhokum?!
sorry just need to work on spelling now
Cliff