--Working w/ ACCESS 2003, I created a pop up modal YES form w/datasheet as
its default view. When I use a CMD button made with the Wizard to open this
form it's opening it up in single form. How can I fix this? Thank you...

Many thanks, Belinda

On Wed, 8 Jul 2009 08:08:01 -0700, Belinda wrote:

> --Working w/ ACCESS 2003, I created a pop up modal YES form w/datasheet as
> its default view. When I use a CMD button made with the Wizard to open this
> form it's opening it up in single form. How can I fix this? Thank you...
>
> Many thanks, Belinda

Regardless of a forms Default View settings being set to Datasheet
View, if you open that form using code you must specify Datasheet
View:

DoCmd.OpenForm "FormName", acFormDS

--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

Awesome!!! Thank You! So simple too! I'm learnign as I go...
--
Many thanks, Belinda


"fredg" wrote:

> Regardless of a forms Default View settings being set to Datasheet
> View, if you open that form using code you must specify Datasheet
> View:
>
> DoCmd.OpenForm "FormName", acFormDS
>
> --
> Fred
> Please respond only to this newsgroup.
> I do not reply to personal e-mail
>