open form in datasheet view - how to? 4

[lauraSatellite]

I have a form that i want displayed in datasheet view.

I have:
default view set to datasheet
allow form view set to No
allow pivot chart set to No
allow pivot table set to No
allow datasheet view set to Yes

When i open the form from the forms section, it opens in datasheet view, however when i open the form from a button in another form, it opens in form view.
If you have any ideas as to why this is happening, i would greatly appreciate your input.

 

[RoyVidar]

Check the openforms code for the button(s). The second arguement, the view arguement, should be acFormDS:

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

Roy-Vidar

 

[hymn]

on the button that opens the form it should be something like
stDocName = "Your form name"
DoCmd.OpenForm stDocName, acFormDS, , stLinkCriteria


Hope this helps
Hymn

 

[lauraSatellite]

That was exactly what i needed, thank you both. Its working just how i wanted it to now.
Thanks again!