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.