Button help

  • Thread starter Thread starter tom
  • Start date Start date
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
 
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.
 
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
 
Back
Top