I have a continuous form that has 48 text boxes (2 per hour) and a total of 4 rows. I want to know how to determine which of those boxes was clicked. When you click the box it opens up a popup form with a combo box. The value of the combo box is then passed back to the box that was clicked.
Maybe you need to look at it to see what is going on. It works if I program each and every textbox, but I am trying to 'automate' it a bit better.
Thanks for taking a look. MoldChanges.accdb
P.S. I have tried something like this on a few form events: Dirty, After_Update, Current. None of those worked.
Dim strActiveCtl As String
strActiveCtl = Screen.ActiveControl.Name
And I may need to know how to do something like Forms!FormName! & Variable. If that is possible.