Open Form in Add Mode

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Bob - 03 Sep 2007 20:38 GMT

I have form that is designed to open in DataSheet Format.. When I open the
form normally it works perfectlhy.

When I open it from switchboard open form in add mode it open in form
view...

What am I doing wrong..

Many thanks

Bob

Reply to this Message

Rick Brandt - 03 Sep 2007 20:48 GMT

> I have form that is designed to open in DataSheet Format.. When I
> open the form normally it works perfectlhy.
[quoted text clipped - 3 lines]
>
> What am I doing wrong..

Even when it is the default view for a form datasheet view has to be explicitly
specified in your OpenForm method.

DoCmd.OpenForm "FormName", acFormDS, , , acFormAdd

Signature

Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

Reply to this Message

Bob - 03 Sep 2007 21:28 GMT

Thanks rick but where do I put this line in the switch board setup..

Thanks Bob

> > I have form that is designed to open in DataSheet Format.. When I
> > open the form normally it works perfectlhy.
[quoted text clipped - 8 lines]
>
> DoCmd.OpenForm "FormName", acFormDS, , , acFormAdd

Reply to this Message

Rick Brandt - 03 Sep 2007 22:10 GMT

> Thanks rick but where do I put this line in the switch board setup..
>
> Thanks Bob

I suppose you would have to create a function and then use the Run Code option.
Sorry, but I never use the Switchboard Manager (often described by Larry Linson
as a complex solution to a simple problem).

I just use my own unbound forms with buttons and/or hyperlinks on them as that
is much more flexible and powerful.

Signature

Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

Reply to this Message