Button to open an Access form in Datasheetview?

[mimitan]

Hi,
I am currently learning Access DB. I created a form with a button when clicked it will open another form. My question is when it open the second form, it default it to Form view, how can I change it to default to Datasheetview?

Here is a few lines of the codes attached to the command button
Sub...
.
.
stDocName = "Form To process update of the Weekly Ad"
DoCmd.OpenForm stDocName, , , stLinkCriteria
.
.
End sub.
Thanks!

 

[PHV]

DoCmd.OpenForm stDocName, acFormDS, , stLinkCriteria

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[mimitan]

Yes,
That was exactly what I was looking for. Thanks PH