Showing datasheet

[michael montagne]

I can't seem to get my form to show datasheet bt default. If I run it
from the databse window, it works just fine. But called from a button
on a different form, and it goes to form view instead. I have the
proerties set to "Defaultview=datasheet' and "Views Allowed=datasheet"

-mjm

[fredg]

On Wed, 14 Apr 2004 15:33:40 -0700, michael montagne wrote:

I can't seem to get my form to show datasheet bt default. If I run it
from the databse window, it works just fine. But called from a button
on a different form, and it goes to form view instead. I have the
proerties set to "Defaultview=datasheet' and "Views Allowed=datasheet"

-mjm

If you open the form from a command button on another form you must
explicitly open it in Datasheet view:
DoCmd.OpenForm "FormName", acFormDS
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.

[michael montagne]

fredg wrote:

On Wed, 14 Apr 2004 15:33:40 -0700, michael montagne wrote:

I can't seem to get my form to show datasheet bt default. If I run it
from the databse window, it works just fine. But called from a button
on a different form, and it goes to form view instead. I have the
proerties set to "Defaultview=datasheet' and "Views Allowed=datasheet"

-mjm

If you open the form from a command button on another form you must
explicitly open it in Datasheet view:
DoCmd.OpenForm "FormName", acFormDS

I love this place!! Thanks.