Detect last object clicked (on Access 2007 form) in BeforeUpdate event procedure
Posted on 2014-10-29
In an Access 2007 form BeforeUpdate event procedure, is there any way of finding out the last object clicked on? (The form's ActiveControl property doesn't do it, because BeforeUpdate fires before the object clicked on becomes active.)
In particular: on a form with a subform, clicking on the subform area triggers the main form BeforeUpdate event. In the BeforeUpdate event procedure, I would like to know whether the subform was the last thing clicked on, so that I can tailor my mainform validation accordingly.