access 2003 how do I determine the control 1

[ProgramError]

Hi all

If a sub is call in the example below how can I determine the name of the the control which called the sub eg in this case cboRoom is the name of the control.

Private Sub cboRoom_click()
.....
end sub
I want to be able to use the name of the control to call another generic proceedure and need to determine which control called it.

Thanks


Ian Mayor (UK)
Program Error
Programming is 1% coding, 50% error checking and 49% sweat as your application bombs out in front of the client.

 

[PHV]

Have a look at the Screen.ActiveControl and Screen.PreviousControl objects.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886