Form wont go into datasheet view ? 1

[christopher007]

I have set the properties of a form for datasheet only by default view and view alowed, however, when i open the form from the database window it goes into datasheet view, when i open the form from a command button created by wizard using docmd.openform it goes back to form view.

Any ideas?

 

[christopher007]

OK I have just examined the code and sorted it thanks.

 

[jojomore]

I am having the same problem with some forms that I am trying to organize with a Switchboard. What do I need to look for to fix the forms to default to datasheet view? I have already set the individual forms to allow only datasheet, and they open fine from the database window. But when I use a Switchboard or a control button to open the form, it goes back to single line form view.
Any help would be appreciated.

 

[RoyVidar]

In the ordinary "open button code" use something like:

[tt]docmd.openform "formname", acFormDS[/tt]

Roy-Vidar