Button help

T

tom

Hi i was hoping someone could help me with a problem. On one of my forms i
have a button that opens another form frmList. The problem is that it opens
the form in single form mode, when i want it to open in datasheet mode. Ive
tried disabling single form view, and making datasheet view the default
view, but this doesn't help. Im sure its a very simple problem. Any help
would be appreciated. Thanks

Tom
 
R

Rick Brandt

tom said:
Hi i was hoping someone could help me with a problem. On one of my forms i
have a button that opens another form frmList. The problem is that it opens
the form in single form mode, when i want it to open in datasheet mode. Ive
tried disabling single form view, and making datasheet view the default
view, but this doesn't help. Im sure its a very simple problem. Any help
would be appreciated. Thanks
Click to expand...

Check the help topic for DoCmd.OpenForm. It has an optional argument you
can supply to make the form open in Datasheet view.
 
F

fredg

Hi i was hoping someone could help me with a problem. On one of my forms i
have a button that opens another form frmList. The problem is that it opens
the form in single form mode, when i want it to open in datasheet mode. Ive
tried disabling single form view, and making datasheet view the default
view, but this doesn't help. Im sure its a very simple problem. Any help
would be appreciated. Thanks

Tom
Click to expand...

Regardless of the form's default view setting, if you open a form
using code, as you are, you MUST specify Form Datasheet view:

DoCmd.Openform, "FormName", acFormDS
 
Top