get data from a textbox on a subform that is set on focus

[Dengkee]

hello ppl,

how to get a data from a textbox on a subform which is currently set on focus?

[Jim Doherty]

In VBA code if you are working from a main form and wishing to take the value from your subform and place the content of that into a string variable the convention is

Dim MyValue As String
MyValue=Forms!YourFormName.Form!YourTextboxName