Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Run-time error '438'
0 views
Skip to first unread message
Sarah at DaVita
Nov 9, 2009, 11:52:12 AM11/9/09
to
I have a form with numerous subforms. Within the subform I am using a
function to hightlight the field the user currently is in. This highlight on
and off is hooked to the got focus and lost focus event on each field the
user can tab to. On the main form I have a button to close the form. When
I click to close I get this error. It points to the hightlight function.
The hightlight function works great when I open each subform individually.
It also works when used in the main form. It only errors when I use the
close button. Can someone help me with this? I think it has to do with the
highlight trying to remove the color when I have clicked out of the form.
Below is what I have hooked to the lost focus.
Function RemoveHighlight()
Screen.ActiveControl.BackColor = vbWhite
End Function
function to hightlight the field the user currently is in. This highlight on
and off is hooked to the got focus and lost focus event on each field the
user can tab to. On the main form I have a button to close the form. When
I click to close I get this error. It points to the hightlight function.
The hightlight function works great when I open each subform individually.
It also works when used in the main form. It only errors when I use the
close button. Can someone help me with this? I think it has to do with the
highlight trying to remove the color when I have clicked out of the form.
Below is what I have hooked to the lost focus.
Function RemoveHighlight()
Screen.ActiveControl.BackColor = vbWhite
End Function
Sarah at DaVita
Nov 9, 2009, 12:22:02 PM11/9/09
to
Ignore this - I put into wrong forum.
0 new messages