Hello,
Anyone could help me with this code. it gives me run-time error 3075 and syntax error missing operator. field cartão is string and Text 105 is the name of control.
Private Sub Text105_Exit(Cancel As Integer)
If Not IsNull(DLookup("[Cartão]", "cartoes", "[Cartão]=" & Me!Text105 & "")) Then
MsgBox "Já existe(m) ação(ões) sobre este cartão. confirme em histórico.", vbCritical + vbOKOnly + vbDefaultButton1, "Duplicate"
End If
End Sub
Thanks in advance