Hi,

If I had 03 forms with similar control

The first two forms had 03 text box.
The third form had a button that must retrieve
all the 03 text box value of the form that is active

As my form need may increase, I don't want
to hardcode it. How do I retrieve the textbox
value from which form. How do I pass the
first object as variable name in the callbyname
function

Example,

For lNo = 1 To lTotal
lValue = Callbyname("form" & lNo, "Text" & lNo,vbGet) <== "form" & lNo error, not a object
Next

Above is my code having problem with the object parameter.

Please kindly advise. Thank you