Solved check if value already exists (1 Viewer)

[eshai]

hi
i have a form for insert students datiles
on the form is failed name "studentid"(text failed) that have index
what i need is when typing a new "id" the code well search if the "id" is already exists

my code

If IsNull(DLookup("[studentid]", "students", Me.studentid <> 0)) Then
     msgbox = "No Record Found"
Else
   msgbox ="my msg" 
End If

 

[isladogs]

Replace the first line with one of the following:

If Nz(DLookup("studentid", "students"),"") ="" Then
OR use
If DCount("studentid", "students") = 0 Then

EDIT: Oops. Right idea but wrongly executed! Use the solution in post #3 or #4 instead!

 

[CJ_London]

try criteria of

"[studentid]=" & Me.studentid

or as colin says, use dcount

if DCount("*", "students","[studentid]=" &  Me.studentid)=0 then
  'no record found

 

[arnelgp]

if studentID is String:

if DCount("*", "students","[studentid]='" & Me.studentid & "'") =0 then
'no record found
else
'your message
end if

 

[eshai]

if studentID is String:

if DCount("*", "students","[studentid]='" & Me.studentid & "'") =0 then
'no record found
else
'your message
end if

work great
thank you

 

[arnelgp]

you're welcome