Open a form in datasheet view

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

hngo - 03 Aug 2005 08:52 GMT

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

Reply to this Message

Allen Browne - 03 Aug 2005 09:36 GMT

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

DoCmd.OpenForm "Form1", acFormDS

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

> I open a form by click on a button from the main form. My probels are
>
[quoted text clipped - 7 lines]
>
> Many thanks

Reply to this Message

Faberman - 03 Aug 2005 09:44 GMT

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.

> Hi,
>
[quoted text clipped - 8 lines]
>
> Many thanks

Reply to this Message