passing value from one form to another 1

[davyre]

Hi,

I have a form named FrmDialogAutoAdd, which reads from the tblCustOrder. Beneath the FrmDialogAutoAdd, I have a variable named UnitID, and there is a button in that form that triggers to load another form called FrmDelta.
Now what I am asking is, how to pass the value of that variable (UnitID) into the FrmDelta, so that I can work around the code in FrmDelta using UnitID variable?

 

[MajP]

If you open the form in dialog you will have to pass the value in the open args parameter. If you do not open it dialog then you can just set the value from the calling form.

 

[davyre]

thanks for the reply. For the open args parameter, do you mean like this?

docmd.openform "FrmDelta", , , , , acDialog, UnitID

can I put two variables in the open args parameter?

 

[PHV]

You may use any string value for OpenArgs.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[davyre]

so if I use

docmd.openform "FrmDelta", , , , , acDialog, UnitID & PONumber

how do I retrieve it in the other form and decide which is which?
is this correct?

xUnitID=CInt(Me.OpenArgs)
xPONumber=CInt(Me.OpenArgs)

 

[PHV]

What about this ?
DoCmd.OpenForm "FrmDelta", , , , , acDialog, UnitID & "," & PONumber

xUnitID = Val(Split(Me.OpenArgs, ",")(0))
xPONumber = Val(Split(Me.OpenArgs, ",")(1))

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[davyre]

nice PHV. Thanks!