Problem getting datasheet view in forms

[dwasbig9]

Hi Group,

I'm creating a maintenance switchboard and am trying to create forms
to update tables and wanted these to appear as datasheets. Although I
have the default view set to datasheet and when opened directly the
form opens in datasheet view, as soon as I try to open the same form
from the mainenance switchboard it opens in single form view. I'm
using Access 2000. Sorry if its a basic error on my part but cant see
what I've missed.

Regards

Don

[Allen Browne]

If you open the form programmaticall y, you need to specify the view you
want, e.g.:
DoCmd.OpenForm "Form1", acFormDS

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

<dw******@gmail .comwrote in message
news:c3******** *************** ***********@e10 g2000prf.google groups.com...

Hi Group,

I'm creating a maintenance switchboard and am trying to create forms
to update tables and wanted these to appear as datasheets. Although I
have the default view set to datasheet and when opened directly the
form opens in datasheet view, as soon as I try to open the same form
from the mainenance switchboard it opens in single form view. I'm
using Access 2000. Sorry if its a basic error on my part but cant see
what I've missed.

Regards

Don

[dwasbig9]

On Dec 13, 1:05 pm, "Allen Browne" <AllenBro...@Se eSig.Invalidwro te:

If you open the form programmaticall y, you need to specify the view you
want, e.g.:
DoCmd.OpenForm "Form1", acFormDS

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users -http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

<dwasb...@gmail .comwrote in message

news:c3******** *************** ***********@e10 g2000prf.google groups.com...

Hi Group,

I'm creating a maintenance switchboard and am trying to create forms
to update tables and wanted these to appear as datasheets. Although I
have the default view set to datasheet and when opened directly the
form opens in datasheet view, as soon as I try to open the same form
from the mainenance switchboard it opens in single form view. I'm
using Access 2000. Sorry if its a basic error on my part but cant see
what I've missed.

Regards

Don- Hide quoted text -

- Show quoted text -

Thank you Allen

[Ron2006]

On Dec 13, 8:03 am, "dwasb...@gmail .com" <dwasb...@gmail .comwrote:

On Dec 13, 1:05 pm, "Allen Browne" <AllenBro...@Se eSig.Invalidwro te:

If you open the form programmaticall y, you need to specify the view you
want, e.g.:
DoCmd.OpenForm "Form1", acFormDS

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users -http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

<dwasb...@gmail .comwrote in message

news:c3******** *************** ***********@e10 g2000prf.google groups.com...

Hi Group,

I'm creating a maintenance switchboard and am trying to create forms
to update tables and wanted these to appear as datasheets. Although I
have the default view set to datasheet and when opened directly the
form opens in datasheet view, as soon as I try to open the same form
from the mainenance switchboard it opens in single form view. I'm
using Access 2000. Sorry if its a basic error on my part but cant see
what I've missed.

Regards

Don- Hide quoted text -

- Show quoted text -

Thank you Allen- Hide quoted text -

- Show quoted text -

The generic switchboard maintenance does not allow for that type of
open.

One way around that is to create a blank form and place your designed
form on it as a child form and make them the same size and then have
the switchboard open the blank form (obviously with a specific name).

Ron

[dwasbig9]

On 13 Dec, 19:08, Ron2006 <ronne...@hotma il.comwrote:

On Dec 13, 8:03 am, "dwasb...@gmail .com" <dwasb...@gmail .comwrote:

On Dec 13, 1:05 pm, "Allen Browne" <AllenBro...@Se eSig.Invalidwro te:

If you open the form programmaticall y, you need to specify the view you
want, e.g.:
DoCmd.OpenForm "Form1", acFormDS

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users -http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

<dwasb...@gmail .comwrote in message

>news:c3******* *************** ************@e1 0g2000prf.googl egroups.com...

Hi Group,

I'm creating a maintenance switchboard and am trying to create forms
to update tables and wanted these to appear as datasheets. Although I
have the default view set to datasheet and when opened directly the
form opens in datasheet view, as soon as I try to open the same form
from the mainenance switchboard it opens in single form view. I'm
using Access 2000. Sorry if its a basic error on my part but cant see
what I've missed.

Regards

Don- Hide quoted text -

- Show quoted text -

Thank you Allen- Hide quoted text -

- Show quoted text -

The generic switchboard maintenance does not allow for that type of
open.

One way around that is to create a blank form and place your designed
form on it as a child form and make them the same size and then have
the switchboard open the blank form (obviously with a specific name).

Ron- Hide quoted text -

- Show quoted text -

Ron,

Many thanks for your reply, I did try that but although it did work it
meant I had more forms than I really wanted. I've now had a chance to
use Allens suggestion and that works fine.

Many thanks to you both.

Regards

Don