Passing Args when opening a new form

[StuartR]

I am passing information from one form to another by creating a variable called InfoFields and then splitting the variable into various parts to assign to new fields.

Unfortunately, the fields that I am trying to pass are different types (numbers and text) and I am getting a mismatch error when I trigger the code.

My Code is ..

Private Sub AddFamilyMemberBttn_Click()

'Capture info to pass to New Form

Dim InfoFields as String

InfoFields = Me.Family_ID + ";" + Me.Full_Name + ";" + Me.Address_Line1 + ";" + etc etc

DoCmd.OpenForm "New_Fam_Mem", acNormal,,,acFormAdd,,InfoFields

End Sub

Me.Family_ID is Numeric and other fields are Text

On my second form I split the args with the following code ..

Private Sub Form_Load()
If Not IsNull(Me.OPenArgs) then
Args = Split(Me.OpenArgs, ";")
Me.Family_ID = CInt(Args(0))
Me.Name = CStr(Args(1))
etc etc
End If
End Sub

This all works fine if I remove the Numeric Field, but Is there anyway of passing multiple args of diffrent types?

Any help would be appreciated

Stuart

[RuralGuy]

The OpenArgs argument of the OpenForm command is *always* a string value. Convert your numeric value to a string to send. The Str() function should do that for you.

[RuralGuy]

BTW, you should use the "&" character for concatenation of strings rather then the "+". The "+" can give you unexpected results on occasion.

[June7]

Use the & for concatenation and won't need to convert numbers.

The + is trying to sum a string and number which causes type mismatch error.

AFAIK, there is only one situation where using + for concatenation is appropriate and that is to concatenate strings and the desire is to suppress punctuation if possibility of Null. For example, if last name will always be available but for some odd reason first name is not:

[LastName] & ", " & [FirstName]

will result in Jones,

[LastName] & ", " + [FirstName]

will result in Jones

[StuartR]

Thanks all ~ "&" instead of "+" solved the issue and I didn't need to convert the numeric field.

[orange]

You may find this info from Barry Williams' site helpful.