dynamically define a nariable name

[markjkubicki]

Not that often, but often enough, i pass several variables to a form through open arguments.
And thought i could streamline the retrieval of them through a simple snippet of reusable code.

(I "think" the answer is you can't do what i'm trying to do... but....)
the problem is defining a variable for each argument (sometimes there is only 1; other times, there may be several (maybe 3 or 4 or 5)
the arguments then get assigned to controls on the form..

here's the code:

Private Sub Form_Load()

    If Len(Me.OpenArgs) > 0 Then
        strOpenArgs = Me.OpenArgs
        intVarCnt = 1
        Do While InStr(strOpenArgs, "|") <> 0
            strVar = srtVar & intVarCnt
            intPos = InStr(strOpenArgs, "|")
            strVar = Left(Me.OpenArgs, intPos - 1)
            strOpenArgs = Mid(strOpenArgs, intPos + 1)
            intVarCnt = intVarCnt + 1
        Loop
        ' and then pickup the last argument (after the last pipe)
        strVar = "var" & intVarCnt
        intPos = InStr(strOpenArgs, "|")
        strVar = Left(Me.OpenArgs, intPos - 1)
        strOpenArgs = Mid(strOpenArgs, intPos + 1)
    End If
    
End Sub

as always, with appreciation in advance,
thnx,
m.

[Micron]

You don't make use of Option Explicit do you? That would be an oversight, I'd say.

I don't see why you can't string together a bunch of parameters for OpenArgs, but not in the load event of the form. There wouldn't be much point as the property is usually set from DoCmd in another form, not in the form you're opening. Makes no sense to me to do it in the opened form and use the parameters after that - might as well pull them in from the second form (from the first?).

[pbaldy]

That code appears to be in the form being opened. I don't think you can do what you're trying to do, but simpler would be to use the Split() function on OpenArgs. That will put however many items were passed into an array, and you can refer to any member of that array easily, or loop it.

[markjkubicki]

Yea…
I kinda noted the option explicit problem
And thought I’d duck it for now (knowing fully it might kill the whole approach)

I do send the arguments with the DoCmd open form…. This is about retrieving them in the new form
The arguments received might be:
textA|textB|textC and I was hoping to break it into textA. textB. textC with generic code for an undetermined number of items

[pbaldy]

Just making sure you noticed post 3.

[markjkubicki]

got it
thnks
....that makes sense

(BTW split().... new language for me; and pretty slick if you ask me. such an obvious code to have !)

[pbaldy]

No problem, post back if you get stuck implementing it.

[Micron]

And thought I’d duck it for now (knowing fully it might kill the whole approach)

You're just asking for trouble.