Get the textbox name

[Jofx]

I would like to get the name of a texbox after this textbox has been updated.

something like:

Sub textboxName_AfterUpdate()
msgbox "The name of the updated textbox"
end

Thanks

 

[KenReay]

See .ActiveControl in help

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[Jofx]

Thanks Ken
I've tried your tip but it doesn't work.
The activecontrol gives the name of a multipage containing textboxes. Any other idea ?

 

[PHV]

Which ActiveControl have you tried ?
Me.ActiveControl.Name or Screen.ActiveControl.Name ?

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

 

[Jofx]

I just tried :
Sub textboxName_AfterUpdate()
msgbox Me.activecontrol.name
end

--> MultiPage1