VBA How To Reference Active/Selected Field?

[Enrightt]

I have a form that contains ~8 different date fields and I want to add a button that will update the currently selected field to today's date.



I don't want to have 8 different buttons.

Is there an Access form equivalent to reference selected field similar to Excel's .ActiveCell?

Thanks!

[RuralGuy]

Research Screen.ActiveControl

[CJ_London]

one thing to be aware of is if you click a button to run some code screen.activecontrol will be the button. So also investigate screen.previouscontrol - and be aware with this if the user has previously clicked on a none date control, or no control at all, your code will fail so will need error handling to manage the failure.

however, why click a button, why not use the control's doubleclick or mouseup (where right button is down) event? Benefit of the latter is if user clicks down, realises they have made a mistake, they can move the mouse off the control before releasing the button, so preventing the mouseup event firing.