Ddisplay form in datasheet view using VB

G

Guest

This is probably very simple, but can anyone tell me how to open a form in
data sheet view using VB. I've set the default view for the form to be
datasheet and when I double click on the form, it opens in datasheet view.
But when I use the code below to open the form it will not open in datasheet
view:

DoCmd.OpenForm stFormName

I've tried all kinds of options with OpenForm, but fails to open the form in
Datasheet View. Any help will be greatly appreciated.
 
G

Guest

I've found the answer to my own question. The code is below if anyone is
interested:
DoCmd.OpenForm stDocName, acFormDS
acFormDS is the key.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I set acformview to datasheet in VB docmd.openform in acce. 1
How to format specific records in Datasheet view 1
datasheet default opening in single form view 2
visibility in datasheet view 2
switchboard button -- setting a form to open in datasheet view 3
Setting allows permissions for a subform in datasheet view 2
Oper Arges 5
Open form as Datasheet 3

Top