Unknown Variable

[simongallop]

I have a list of extensions that can change on a monthly basis. I need to use code to assign data to variables being one variable per extension. Is there a way of having part of the variables name being the extension number (ie for extn 4932 have variable 4932Call)

 

[simongallop]

Already do. Just wondering whether it could be done as it would cut out a lot of the coding within both Access and Excel. Guess that I will just have to stick to going through the data numerous times. Thanks anyway.

 

[simongallop]

Better example is that I have a form where upto six items can be entered. the textboxes are called txtA1, txtA2 etc. Depending on the number of items can I get the code to look at txtA & Var (where Var is the item number?)