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 programmatically, 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**********************************@e10g2000 prf.googlegroups.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" <[e-mail]:

If you open the form programmatically, 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.

<[e-mail] in message

news:c3**********************************@e10g2000 prf.googlegroups.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, "[e-mail]" <[e-mail]:

On Dec 13, 1:05 pm, "Allen Browne" <[e-mail]:

If you open the form programmatically, 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.

<[e-mail] in message

news:c3**********************************@e10g2000 prf.googlegroups.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 <[e-mail]:

On Dec 13, 8:03 am, "[e-mail]" <[e-mail]:

On Dec 13, 1:05 pm, "Allen Browne" <[e-mail]:

If you open the form programmatically, 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.

<[e-mail] in message

>news:c3**********************************@e10g200 0prf.googlegroups.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