Referencing Form Text Boxes 1

[Russie]

Hi.

I have a list of text boxes with similar names:

txtAvalue
txtBvalue
txtCvalue

I'm using code to run queries and perform calculations.

Currently I have to refer to the form text boxes as:

[Forms]![frmtest].txtAValue.value = x
[Forms]![frmtest].txtBValue.value = y

What I want to do is to refer to them using a regional variable:

i.e. variable 'strReg' indicates region...so.

[Forms]![frmtest].txt & (strReg) & Value.value = x

could fit all text boxes depending on strReg's value.

Question:

How can I insert a string variable into a form reference?

A star for a workable answer.

Thanks for anything.

Russie

 

[mp9]

Untested but try something like:

[Forms]![frmtest].Controls("txt" & strReg & "Value").value = x

... I think!

http://www22.brinkster.com/accessory/

 

[Russie]

You thought right.

Thanks.