OpenArg help.

[manic]

Can anyone look at this code and let me know how I can use it to pass more than two values to a form from another. this is what I have on form1

DoCmd.OpenForm "frm_safety_investigation", , , , , , Me![Incident_Number] & "," & Me![Employee_Involved_1]

and on form 2 on the load event i have this

Private Sub Form_Load()
If Not IsNull(Me.OpenArgs) Then
Incident_Number = Left(Me.OpenArgs, InStr(Me.OpenArgs, ",") - 1)
Corrective_Action_Number = Left(Me.OpenArgs, InStr(Me.OpenArgs, ",") + 1)
end if
end sub

but I can't figure out to save my life how to make it pass more than just two fields with the openarg method.
any help would be appreciated.

[pbaldy]

See if this helps:

http://www.baldyweb.com/OpenArgs.htm

[pbaldy]

I should add that you can loop the array resulting from the Split() function if there will be a variable number of items passed.

[manic]

Thank you , you solved my issue.

[pbaldy]

Happy to help!