Lost Focus/Test control with focus???

[RollingMoose]

We have a form with various text boxes, checkboxes, etc. When the user moves out of a textbox("Name&quot, we use the lost focus event to look for address information in a database. If none is there, we show a message that no information was found. We would like to suppress or not show our message if the user clicks on a specific checkbox. Any suggestions on how we can accomplish this?? Thanks in advance.

 

[zemp]

In the lost focus event you can check the state of the check box first.

Private sub Text1_LostFocus()
If Check1.value = 0 then
msgbox "????"
End if
End Sub Thanks and Good Luck!

zemp

 

[CajunCenturion]

Instead of using the LostFocus event, you might try using the Validate event, and then in the checkbox, set the .CausesValidation property to false Good Luck
--------------
As a circle of light increases so does the circumference of darkness around it. - Albert Einstein