Datasheet View property does not work consistently

[Guest]

Greetings...

I've set my form properties to permit datasheet view only however when I
initially open the form . . . it goes directly to the "Form View"...not
datasheet...

Is there something that I may add to the "On Open" event property to remedy
this?

V/R,
Steve

 

[Allen Browne]

If you open the form from the Database window, it will open in whatever you
defined in its Default View property.

If you use OpenForm to open it programmatically, specify the view, e.g.:
DoCmd.OpenForm "Form1", acFormDS

 

[Guest]

When I entered the following command into the "On Open Event Property":

DoCmd.OpenForm "Frm_MethodCount", acFormDS

I get the following error message:

Run time error '2174'
You can't switch to a different view at this time

Was I correct to replace "Form1" w/ the actual name of my form? If so, I'm
not sure why I'm getting the error message...

p.s., when I open the same form w/ a macro...it opens properly in datasheet
view...

Steve

 

[Allen Browne]

The code does not go into the On Open property of the form.

Presumably the form is closed at the time you want to open it.

If you are opening it with code such as the Click event of a command button:
1. Set the button's On Click property to:
[Event Procedure]

2. Click the Build button (...) beside that.
Access opens the code window.

3. Add the line to the event procedure, in between the "Private Sub..." and
"End Sub" lines.

 

[Guest]

duh...don't I feel stupid...

Thanks for your time and patience...

Steve

The code does not go into the On Open property of the form.

Presumably the form is closed at the time you want to open it.

If you are opening it with code such as the Click event of a command button:
1. Set the button's On Click property to:
[Event Procedure]

2. Click the Build button (...) beside that.
Access opens the code window.

3. Add the line to the event procedure, in between the "Private Sub..." and
"End Sub" lines.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

When I entered the following command into the "On Open Event Property":

DoCmd.OpenForm "Frm_MethodCount", acFormDS

I get the following error message:

Run time error '2174'
You can't switch to a different view at this time

Was I correct to replace "Form1" w/ the actual name of my form? If so,
I'm
not sure why I'm getting the error message...

p.s., when I open the same form w/ a macro...it opens properly in
datasheet
view...

Steve