Opening form in datasheet view

[davegb]

I learned recently that I should never allow end users access to my
tables, that if I want them to see that data in that format I should
show them a datasheet form. I created a form for this purpose. When I
double click on the form in the database window, it comes up in
datasheet view. But I created a button in my switchboard to bring up
this form, and it shows up with only one record showing, not the whole
table. Is there some kind of special command to get it to do this?
Right now, the button command is:

DoCmd.OpenForm "frmdtsCWEmployeeAll"

Why doesn't this open the form the same way I see it when I double
click on the form?
Thanks.

[fredg]

On 21 Dec 2005 14:42:41 -0800, davegb wrote:

I learned recently that I should never allow end users access to my
tables, that if I want them to see that data in that format I should
show them a datasheet form. I created a form for this purpose. When I
double click on the form in the database window, it comes up in
datasheet view. But I created a button in my switchboard to bring up
this form, and it shows up with only one record showing, not the whole
table. Is there some kind of special command to get it to do this?
Right now, the button command is:

DoCmd.OpenForm "frmdtsCWEmployeeAll"

Why doesn't this open the form the same way I see it when I double
click on the form?
Thanks.

To open a form from an event, regardless of the form's default view
setting, you MUST specify datasheet view:

DoCmd.OpenForm "frmdtsCWEmployeeAll", acFormDS

--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

[davegb]

fredg wrote:

On 21 Dec 2005 14:42:41 -0800, davegb wrote:

I learned recently that I should never allow end users access to my
tables, that if I want them to see that data in that format I should
show them a datasheet form. I created a form for this purpose. When I
double click on the form in the database window, it comes up in
datasheet view. But I created a button in my switchboard to bring up
this form, and it shows up with only one record showing, not the whole
table. Is there some kind of special command to get it to do this?
Right now, the button command is:

DoCmd.OpenForm "frmdtsCWEmployeeAll"

Why doesn't this open the form the same way I see it when I double
click on the form?
Thanks.

To open a form from an event, regardless of the form's default view
setting, you MUST specify datasheet view:

DoCmd.OpenForm "frmdtsCWEmployeeAll", acFormDS

--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

Thanks! Works great now.