OpenForm in dialog

[Daniel]

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

 

[Marshall Barton]

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

 

[Daniel]

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

Daniel P