Open Form From Command Button

[Guest]

I have a record entry form that I use in datasheet format to enter records. I
created a form to use as a menu with a command button that opens the record
entry form however when I open the form it does not open as a datasheet, but
rather a single form.

Is there a way to open the form in datasheet view through the command
button? I do not want to ever view the form in single form.

Thanks.

 

[JoelH]

the onClick event procedure of command button should read something
like:
docmd.OpenForm "your form's name", acFormDS

this stipulates that the form should be opened in datasheet view

 

[fredg]

I have a record entry form that I use in datasheet format to enter records. I
created a form to use as a menu with a command button that opens the record
entry form however when I open the form it does not open as a datasheet, but
rather a single form.

Is there a way to open the form in datasheet view through the command
button? I do not want to ever view the form in single form.

Thanks.

Regardless of the default view property of the form, to open a form in
datasheet view using code, you must explicitly open it in Datasheet
view.
Code a command button click event:
DoCmd.Openform "FormName", acFormDS