Is there a way to determine the "current" field? 1

[Dor100]

Is there perhaps a "current" field just as there is a current record? I'm trying to use VBA to enable users to click a button and have check marks placed in every row for a specific field of a subform whose cell has the focus. So far I've come up dry after searching Help and the net. This elusive "current" field would naturally be present within the current record. Thanks to anyone who has a solution.

 

[PHV]

Take a look at the ActiveControl and PreviousControl properties.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[Dor100]

Thanks, PH. I discovered that you can append ".Name" ('.ActiveControl.Name') and get exactly what is needed. This is excellent - can't thank you enough.