I am trying to write a function that will bring back as a string the name of the form with focus
i have found the ISOPEN() function in the AccessVBA book but you have to specify the form name. Does anyone know how i can return the form with focus name without having to specify it first
jon
Sun, 03 Mar 2002 03:00:00 GMT
Radu Lasca #2 / 2
Bring back name of openform as string
Hi Jon,
Screen.ActiveForm.Name
Hth, Radu Lascae
Quote:
> I am trying to write a function that will bring back as a string the name of > the form with focus
> i have found the ISOPEN() function in the AccessVBA book but you have to > specify the form name. Does anyone know how i can return the form with focus > name without having to specify it first
Bring back name of openform as string