OpenForm in dialog

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Daniel said:
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.
Click to expand...


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
 
That's a new one for me. Thank you! I always wondered what the openargs was
about.

Daniel P
 
Back
Top