Help with Dlookup

[taimysho0]

hello, i have a textbox on a form where someone will be adding new users to the tblUser. However, if the name already exists in the tblUser, then message will appear notifying the user. However, my code is only looking at the first value of the "user" column and not at the whole column. it will throw the error message only for those first name in that column, how do i get it so it look at the WHOLE row and not just the first row? thanks!




my code:

If Me.txtName = DLookup("Users", "tblusers", "Users") Then
'Look up the _____ field, from the _____ table, where the record is _____


MsgBox ("This Name Already Exists!")
Me.txtName = ""
End If




^"Users" is the name of my User Name column

[taimysho0]

nevermind, used

Private Sub txtName_AfterUpdate()
If Me.txtName = DLookup("Users", "tblusers", "Users = '" & txtName & "'") Then
'Look up the _____ field, from the _____ table, where the record is _____


MsgBox ("This Name Already Exists!")
Me.txtName = ""
End If

[RuralGuy]

Thanks for sharing your solution.