Datasheet view from switchboard selection

  • Thread starter Thread starter Guest
  • Start date Start date
How do I go directly to a dataheet view when making a selection on a
switchboard?
Click to expand...

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
 
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?
 
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?
Click to expand...

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.
 
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.
 
Back
Top