Problem with stored textbox names

[hbrems]

Hello,

I need to look up a textbox name in a table and then refer to the same texbox on my form.

For example (how it should work in theory):

vformname = dlookup("fldformname", "tblfilter", where xxx)
me.vformname = 29/10/2007

How can I make this work?

Kind regards,
Hans B.

 

[KenHigg]

You should be able to concatenate a string and a variation of the following code:


strMyControlName = "myTextBoxName"

me("myTextBoxName")




ken

 

[hbrems]

Simply but effective. Thanks a lot Ken!

 

[KenHigg]

Glad to help