[RESOLVED] Textbox return

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..

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) ;)

Access VBA question moved to Office Development.

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.

Quote:

---

Originally Posted by 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) ;)

---

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