Open a form in datasheet view

[Guest]

Hi,

I open a form by click on a button from the main form. My probels are

1) how do we makesure that the form is aways open in data sheet view. I
have set the current default view to datasheet. However everytime you open
the form in always open in the single form view.

2) How do we set so that the new form always open in a particular location
and size all the time

Many thanks

 

[Allen Browne]

Specify the View when you OpenForm, e.g.:

DoCmd.OpenForm "Form1", acFormDS

 

[Guest]

Hi there.

1) I usually use the "Views Allowed" form property as well as the "Default
View" property. If I want a form to appear as a datasheet, I set both
properties to Datasheet. Worth a try.

2) Check out the "MoveSize" function. I don't use it myself, but I think it
will do what you want.