Concatinate an Object Name with String Variable 1

[tomhughes]

tomhughes (Vendor) 16 Feb 07 9:38
I am trying to concatenate an object name with a string Variable. The last letter of the Text Box name changes. If I hard code the letter in the name the string returns the proper value.

This text string returns the proper value.

str = " '" & Forms!frmMain.TopicHead[b][COLOR=red]A[/color] [/b]& "'"

I need to use a string variable to change the last letter of the name.
I have tried numerous string arrangements, with no success, it would seem to me that this string arrangement should work.

strTabNo = "A"
str = '" & Forms!frmMain.TopicHead & strTabNo & "'"

but it gives me the following error

Run-time error '2465'
Application-defined or object-defined error

There has got to be a way of doing this. Does anyone know how???

 

[PHV]

strTabNo = "A"
str = "'" & Forms!frmMain.Controls(TopicHead & strTabNo) & "'"

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[tomhughes]

PHV
THANKS!THANKS!THANKS!THANKS!THANKS!THANKS!THANKS!THANKS!

I had to put quotes around the word TopicHead. I've been working on this for days, pulling my hair, and don't have much to pull out.