active field 1

[rene1000]

I want to create a button which inputs the date into the current active field (with the focus on it). Therefore i need to read the current active field name. How can i do this ?

 

[Eupher]

Well, if you want to refer to the name of the current field, you would use Screen.ActiveControl.Name

But if you want to click a button and put a value in that field, that won't work, because as soon as you click the button, the button gains focus and the other field is no longer the current control. In that case, you'd use Screen.PreviousControl, i.e. to insert the current date:

Screen.PreviousControl = Date

HTH...

Ken S.

 

[rene1000]

Thank you very much Ken, it works great and it was very helpfull.