Testing for name of a Frame Control

[batteam]

I have a form with many frame controls on it. I am storing a portion of the Frame contol's name in a table along with that frame's value, i.e.: 1701 | 2 | ; these values refer to fra1701 with a value of 2 on my form. When I read out this row from my table, I want to concatenate "fra" & 1701 to get the name of that control (fra1701 on my form), thus have it valued on my form as follows:
varFrameValue = 2
varFrameName = 1701
varFrameNameFinal = "fra" & varFrameName
varFrameNameFinal.Value = varFrameValue

I get an error with this code, indicating that the method (.value) cannot be found, so I'm looking for a way to assign a variable with the .value method of the frame control. If this can't be done, I will have to do a big Select Case stmt that would interegate every frame control on my form and compare it to varFrameNameFinal, and repeat for every row I bring in from my table.

Any help would be appreciated. Thanks.

 

[Hap007]

Hi batteam,

Give this line of code a try:

Me(varFrameNameFinal).Value = varFrameValue

Hope This Helps,
Hap...

Access Developer

http://www.fcs-software.com/fcsaccessdev.html

Access based Accounting Solutions - with free source code
Access Consultants forum

http://www.tek-tips.com/threadminder.cfm?pid=1121

 

[batteam]

That seemed to do the trick. Thanks so much for your help.