Switchboard

[jmatdrama]

I have a form that is in spreadsheet view. I have
disabled form view because the user needs to see all
available records. Unfortunately when I use the
Switchboard to open the form, it won't open in
spreadsheet view but insists in open in single record
view, even though it is disabled. Anybody know how I can
get it to open in spreadsheet view?

 

[fredg]

I have a form that is in spreadsheet view. I have
disabled form view because the user needs to see all
available records. Unfortunately when I use the
Switchboard to open the form, it won't open in
spreadsheet view but insists in open in single record
view, even though it is disabled. Anybody know how I can
get it to open in spreadsheet view?

It depends.

A form, opened from an event on another form, must always be opened
explicitly in Datasheet view.

What switchboard?
One you created using an unbound form with command buttons?
Code the click event of the command button:

DoCmd.OpenForm "FormName", acFormDS

A Switchboard you created using the Switchboard manager add-in?
You'll need to add a constant to the HandleButtonClick function
Const conCmdOpenFormDS = 9 (use a number 1 higher than the highest
constant number already used)

Then add , down with the rest of the Select Case statements in this
function:

Case conCmdOpenFormDS
DoCmd.OpenForm rst!Argument, acFormDS

Then modify the Switchboard Items table by changing the Command value
to this new constant number value.

 

[jmatdrama]

The switchboard was created through switchboard manager.
I solved the problem by running it through a macro and
telling the macro to open in datasheet view. For some
reason when I opened the form, it worked perfectly, but
when I opened the same form from the switchboard, it
insisted on form view. Anyway, the macro solved it with
no problem. Thanks
Jeannie