Set Default Form Mode to Continuous?

[steph]

Hi,

I' have this form where the default view is datasheet. However, users
should be able to change to a continuous-form view.

When I set the default view to continuous-form, then it's no problem to
switch between datasheet and continuous-form. But when I set the
default view to datasheet, I only can switch to single-form mode, not
to contiuous-form mode.

Can this behaviour be changed, so that default view is datasheet, but I
still can change to continuous form? What would be the corresponding
properties I have to set?

I'm using Microsoft Access 2002, SP3.

br,
Stephan

 

[fredg]

Hi,

I' have this form where the default view is datasheet. However, users
should be able to change to a continuous-form view.

When I set the default view to continuous-form, then it's no problem to
switch between datasheet and continuous-form. But when I set the
default view to datasheet, I only can switch to single-form mode, not
to contiuous-form mode.

Can this behaviour be changed, so that default view is datasheet, but I
still can change to continuous form? What would be the corresponding
properties I have to set?

I'm using Microsoft Access 2002, SP3.

br,
Stephan

I don't believe there is any code to go from Datasheet to Continuous
View directly.
I would do it differently.
Leave the Default View as Continuous.
However, when you open the form, open it from a command button,
specifying Datasheet view:

DoCmd.OpenForm "FormName", acFormDS

The form will open in datasheet view.
Then, when you are ready, it's simply a matter of changing the view to
the default Continuous, either through the View ToolButton or code in
a control's double click event:
DoCmd.RunCommand acCmdFormView

 

[steph]

That sounds like an option I could take. However, can I also set the
form-view programmatically in an event?

 

[fredg]

That sounds like an option I could take. However, can I also set the
form-view programmatically in an event?

Did you not read this part of my reply?

Then, when you are ready, it's simply a matter of changing the view to
the default Continuous, either through the View ToolButton or code in
a control's double click event:
DoCmd.RunCommand acCmdFormView

Note: Always include the relevant portion of the message you are
replying to. It makes it easier for someone to reply to whatever you
are replying to without having to go back and find the previous
message. It also makes it easier for someone reading this message
without the benefit of seeing the previous ones to understand it.
Thanks.

 

[steph]

i have really overlooked your hint, i'm sorry

i have solved my problem now like this:
i've set my form's view to continuous. I have created a dummy form
which is called at startup. in the on-open event of this startup form
my main form is called in datasheet-view as you have proposed. then i
close the startup-form and thus focus goes to my main form. works fine
- thanks for your hints!

br,
stephan