i have a record validation performed on the before-update procedure.If the record isn't valid and i cancel it i need to omit the default msgbox and add my own so i can grab values ie cancel,ok i am using access97
anyhelp would be appreciated
s-)
what i have done is used code for form_unload.I have cancelled the close but i then get a msgbox"You cant save this record at this time".I am tryingto get rid of this msgbox somehow
might be fighting a losing battle
Sounds like you have a key or index violation. Try adding this bit of code into what you have. It'll wipe out all active TextBoxes and ComboBoxes.
Sub DeleteControls()
Dim conControl As Control
For Each conControl In Me.Controls
If conControl.Properties("ControlType" = acTextBox Or conControl.Properties("ControlType" = acComboBox Then
conControl = ""
End If
Next conControl
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.