L Laura New member Local time Today, 10:25 Joined Jun 15, 2000 Messages 8 Jun 19, 2000 #1 How can I display a MsgBox showing a warning if the user violates a multiple index and enters repeating data?
How can I display a MsgBox showing a warning if the user violates a multiple index and enters repeating data?
I ingvar68 Registered User. Local time Today, 10:25 Joined Jun 22, 2000 Messages 21 Jun 22, 2000 #2 use the followin vb glad to answer Private Sub Form_Error(DataErr As Integer, Response As Integer) If DataErr <> 3022 Then Exit Sub Call MsgBox("You entered the value elready existed.You must enter new value.", vbOKOnly) Response = Cancel End Sub
use the followin vb glad to answer Private Sub Form_Error(DataErr As Integer, Response As Integer) If DataErr <> 3022 Then Exit Sub Call MsgBox("You entered the value elready existed.You must enter new value.", vbOKOnly) Response = Cancel End Sub
