I've seen the question in some older posts but couldn't really find an answer which i like ;p
assume i have a textbox called txtUsername and a button called cmdOk.
when cmdOk gets clicked the following code should be triggered :
Msgbox "Hello " & txtUsername.text & ".", vbokonly, "Hello"
this will generate an error unless i give txtUsername focus first (txtUsername.setfocus).
the textbox is in no way related to a field in the database , it's just a plain standalone textbox.
any way to get a textbox's value without focussing it first ? (since this method kinda sucks if you need the value of 20 fields)