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.

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


strMyControlName = "myTextBoxName"

me("myTextBoxName")



:)
ken

Simply but effective. Thanks a lot Ken! :)

Glad to help :)