Open form in Datasheet View?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Randy - 23 Sep 2005 14:28 GMT

How can I force a form to open in Datasheet view?

I want to open the Datasheet view fromf the switchboard. I have gone
into properties and turned off the other views but it still comes up in
the form view.

Thanks for any help.

Reply to this Message

MS learner - 23 Sep 2005 16:09 GMT

Hi,

I don't know if it will work but have you tried setting the form property on
Form.Load to open in Datasheet view? Is that possible?

> How can I force a form to open in Datasheet view?
>
[quoted text clipped - 3 lines]
>
> Thanks for any help.

Reply to this Message

fredg - 23 Sep 2005 16:33 GMT

> How can I force a form to open in Datasheet view?
>
[quoted text clipped - 3 lines]
>
> Thanks for any help.

Regardless of the form's default view setting, if you wish to open the
form in Datasheet view using a command button event, you MUST
explicitly open the form using:
DoCmd.Openform "FormName", acFormDS

Signature

Fred
Please only reply to this newsgroup.
I do not reply to personal email.

Reply to this Message

Jeff Conrad - 23 Sep 2005 17:05 GMT

If you are using the built-in Switchboard Manager see this page:

http://home.bendbroadband.com/conradsystems/accessjunkie/switchboardfaq.html#dat
asheet

(Watch out for any line wrapping on that link)

Signature

Jeff Conrad
Access Junkie - MVP
http://home.bendbroadband.com/conradsystems/accessjunkie.html
http://www.access.qbuilt.com/html/articles.html

> How can I force a form to open in Datasheet view?
>
> I want to open the Datasheet view fromf the switchboard. I have gone
> into properties and turned off the other views but it still comes up in
> the form view.

Reply to this Message