OpenForm in dialog

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Daniel - 05 Jul 2007 22:32 GMT

Hello,

I am using a notinlist event to open another form in dialog mode to force
the user to make a new entry then update the cbo.

To simplify the user's life i would like to transfer the NewData value into
the newly opened dialog form but the code pauses as soon as the form is
opened. How can I do this? I know I'm missing something really simple.

I swear if my head wasn't screwed on tight...I'd loose it.

Thank you,

Daniel P

Reply to this Message

Marshall Barton - 05 Jul 2007 23:39 GMT

>I am using a notinlist event to open another form in dialog mode to force
>the user to make a new entry then update the cbo.
>
>To simplify the user's life i would like to transfer the NewData value into
>the newly opened dialog form but the code pauses as soon as the form is
>opened. How can I do this? I know I'm missing something really simple.

Pass the new data string in the OpenForm method's OpenArgs
argument.

DoCmd.OpenForm "the other form", _
                    WindowMode:= acDialog, _
                    OpenArgs:= NewData

Then in the other form's Load event:

    Me.sometextbox = Me.OpenArgs

Signature

Marsh
MVP [MS Access]

Reply to this Message

Daniel - 06 Jul 2007 01:20 GMT

That's a new one for me. Thank you! I always wondered what the openargs was
about.

Daniel P

> >I am using a notinlist event to open another form in dialog mode to force
> >the user to make a new entry then update the cbo.
[quoted text clipped - 13 lines]
>
> Me.sometextbox = Me.OpenArgs

Reply to this Message