[RESOLVED] Textbox return

[vonoventwin]

I resolved a thread, but still need help. I created a little access database to take three text boxes and combine them into one. But I keep getting a You can't reference a property or control that doesn't have focus. What is the way around it? I attached a zip of it..

[Static]

in access u cant reference the .Text Value unless it has focus (As stated)
instead use Text1.Value

(or is it the other way around?? lol)

[Hack]

Access VBA question moved to Office Development.

[salvelinus]

You could .SetFocus the textbox, get the text in a string variable, .SetFocus the next, add that text to the variable, etc, then set the text of the destination textbox. That's a generic way of referencing controls.

[vonoventwin]

in access u cant reference the .Text Value unless it has focus (As stated)
instead use Text1.Value

(or is it the other way around?? lol)

Thanks! That was it. I really needed that too, it happens all the time.