Problem with forms on Switchboard

[Big Time]

I have a form that is based on a parameter query that needs to be opened in
datasheet view. I have set the default view to datasheet and disallowed all
other types of views other than design view. When I open the form directly,
after entering the appropriate parameters, the form opens up in datasheet
view.

However, when I access this form through the Switchboard, it always opens
the form in Form view rather than Datasheet view. How can I set the
Switchboard to open the form in datasheet view?

Thanks in advance for any help provided.

Mike

[Big Time]

And five minutes after using Google I found the answer. I needed to change
the code in the Switchboard for opening forms in Edit mode to the following:

Case conCmdOpenFormBrowse
DoCmd.OpenForm rs![Argument], acFormDS

By adding acFormDS to the end, it forces the form to open in datasheet view.

Anyway, as you were people!

Cheers,

Mike

"Big Time" <bi************@remove-for-spam-hotmail.com> wrote in message
news:ce**********@lettuce.bcit.ca...

I have a form that is based on a parameter query that needs to be opened in datasheet view. I have set the default view to datasheet and disallowed all other types of views other than design view. When I open the form directly, after entering the appropriate parameters, the form opens up in datasheet
view.

However, when I access this form through the Switchboard, it always opens
the form in Form view rather than Datasheet view. How can I set the
Switchboard to open the form in datasheet view?

Thanks in advance for any help provided.

Mike