I am a fairly new user to Access, and I am unsure of what you're talking
about. If I can change the code to the way you describe, is this the code
for the form, or I would probably be guessing, the code for the switchboard?
How do I view the code to make this change?
chris
The code would be on the switchboard.
The problem, Chris, is that you asked a broad question and are looking
for a specific answer.
What kind of switchboard?
Did you create it yourself using an unbound form with command buttons?
Do you know how to find the code?
If so, what is the actual code used to open the form?
Generally, find the command button that you use to open the form and
change it's click event code to:
DoCmd.OpenForm "FormName", acFormDS
substituting the actual form name for "FormName".
You may have additional code involved so all I can do is give you a
generic answer.
If, however, you used the switchboard created by the built-in
Switchboard Manager, you do have a bit of additional work. If that is
the case, post back with more information.
Do you always wish to open that form in Datasheet and never in Single
or Continuous view?
Do you use the switchboard to open other forms in continuous or single
view?
You can add a constant command to open the form in DS, however you
will have to manually change a value in the Switchboard Items table.
The Switchboard manager cannot do this for you. You'll need to post
back.