View on open

[tjr222]

I have a switchboard which links to several forms in my database. I would like to be able to control the way each form opens. For example on a form called 'orders' I would like to have it open in datasheet view and be as large as it can be. I changed the 'orders' form default view to datasheet. The form opens correctly when it is opened it normally. When it is opened through the switchboard,however, it opens in form view and only shows one record. If anybody knows a way I can fix this problem or how to generally manipulate the way each form opens through the switchboard please let me know. Thank you in advance.

 

[fernin8r]

Yeah,

For the button...look at the code.

it should say something like this:

stDocName = "orders"
DoCmd.OpenForm stDocName, , , stLinkCriteria

Add acFormDS into the the code like this

stDocName = "orders"
DoCmd.OpenForm stDocName, acFormDS, , stLinkCriteria

This willl open the form in datasheet view using the button.

to maximize the form,

I would, first set the form properties so that AutoSize and AutoCenter are set to NO then Position and Size the Form window the way you want it (althought you can't use the maximize button) . Just make it as big as possible. Then save the form and it should open to the same size and position.

(this may not be the best way to do the maximizing, but that's all i can think of right now)