I have a form bound to a query. Each field in this control is bound to a field in the query. I use the Screen.ActiveControl command to retrieve the control which has the focus, as shown below. How can I retrieve the (query) field name associated with the control which has the focus?
dim ctr as control
set ctr = Screen.ActiveControl 'now that I know the control with the focus, what is the field name associated with this control?
Thanks