Datasheet view from switchboard selection

[Guest]

How do I go directly to a dataheet view when making a selection on a
switchboard?

 

[fredg]

How do I go directly to a dataheet view when making a selection on a
switchboard?

Regardless of a form's Default View setting, to open any form from a
code event, you must specify Datasheet view.

DoCmd.OpenForm "FormName", acFormDS

 

[Guest]

Fred,

Thank you for your response, however I am very new to the design aspect and
don't know how to write a module to do this. Does this require knowing
Visual Basic? Is there another way? I would like to learn, can you provide
a little direction?

 

[fredg]

Fred,

Thank you for your response, however I am very new to the design aspect and
don't know how to write a module to do this. Does this require knowing
Visual Basic? Is there another way? I would like to learn, can you provide
a little direction?

Yes I can provide some direction, but ....
is this the built in Switchboard created by the Access Switchboard
Manager, or a switchboard created by yourself, using an unbound forms
with command buttons? The how to will be different, depending upon
your reply.

Unfortunately, I have to leave now, so answer the above, and perhaps
someone else will step in and help you, or I will tomorrow morning.

 

[Guest]

The switchboard was created by Access Switchboard Manager.

 

[Pat Hartman \(MVP\)]

The switchboard manager does not provide an option to open a form in ds
view. To get around this, create a macro (yes it's me recommending a macro)
or a VBA function if you are able to (this is better because you can add
error trapping). Then have the switchboard run the macro or function.

 

[Joan Wild]

See
http://home.bendbroadband.com/conradsystems/accessjunkie/switchboardfaq.html#datasheet

 

[Guest]

Thank you all for the assistance. I am up and running.