How do I? : Use a variable in place of a method or property. 1

[thefarg]

Hi. I am trying to replace

rst!(varMyvariable) = strSoundName
varMyvariable = "[Event" & MyCloseObject.[Tag] & "]"

where rst is a recordset. I have tried concatenating differently but to no avail. How do I do this correctly? I have a number of Fields, Event1, Event2, Event3 etc. MyCloseObject.[Tag] is a number1-20, I want concatenated to end up with the field name, i.e Event1, Event2 etc. Any ideas?

 

[PHV]

Replace this:
rst!(varMyvariable) = strSoundName
with this:
rst.Fields(varMyvariable) = strSoundName

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

 

[thefarg]

Yes, this works perfectly. Thanks