Forms again

[cynaptic]

I have a form that I would like to view as a datasheet. I have a button from the menu that calls the form, once clicked it comes up fine except that it is normal form view not datasheet. I have set the defalut view property to datasheet, but it doesn't seem to want to know....

What am I doing wrong?

TIA

 

[Uriel365]

In the code underlying the button ensure that the form opens using "DoCmd.OpenForm "frmName", acFormDS" . This should open the form in datasheet view.

 

[organizer]

I think if you set the "views allowed" property (directly under the "default view" property in 97) to datasheet as well, it will probably solve your problem.

-cynthia