Switchboard

[Slacy]

I have created a switchboard in Access 2000. For some
reason my forms are not holding. I just want them to look
like a datasheet. Am I missing something? All my reports
are holding. Please help! Thanks

 

[Allen Browne]

Change the OpenForm code to specifically open in datasheet view:
DoCmd.OpenForm "MyForm", acFormDS

 

[Slacy]

Allen, thanks for the info. I had changed it to open in
datasheet view, but with no luck I am still getting a form
layout. I have changed this in the property box. The
strange thing is when I open it without going thru the
switchboard it opens in datasheet view. Any suggestions?
Thanks

 

[Allen Browne]

The fact that it opens in datasheet view when opened from the database
window shows you have set the property correctly.

The fact that it opens in Form view when opened through code indicates that
you have not supplied the acFormDS argument correctly.

 

[slacy]

Okay, makes sense. Where do I correct that at? I used
the switchboard manager to help create my
switchboard....thanks many!!!

 

[Allen Browne]

Slacy, I find the built-in Switchboard is not powerful enough for most
things. You may need to create your own unbound form with the command
buttons you want, and then specify the desired code in the Click event of
each command button.