.FindFirst results in the data type mismatch

[mjj4golf]

Hi again, I am trying to find a record using a phone number. The parents table has field for the phone number which is a short text. The form I use has an unbound
text box for the input of the phone number. I then use the subroutine below to find out if a record exists with that phone number. But I get a daily type mismatch when I execute the .FindFirst I have researched access documentation and thought I was doing everything right but apparently I'm not. Can somebody please point out what I am doing wrong. Thank you in advance!

PhoneExist = "[Phone]= " & Me![Phone]
If IsNull(Me![Phone]) Then
message = "Please enter a phone #!"
Else
With rstParents
.MoveFirst
.FindFirst [PhoneExist]
If Not .NoMatch Then
Me![Mother's Name] = ![Mother's Name]
Me![Mother's Name] = ![Father's Name]


rstStudents!ParentID = rstParents![ID]
Me.Refresh
End If
End With
End If

[aytee111]

Hard to tell without the whole subroutine here. You could also use a DLookUp which will give you the same result, except that then you would need to populate the fields - this could be accomplished by having a bound form and using a filter.

[Missinglinq]

If the phone number is (Short)Text, the syntax should be

"[Phone]= '" & Me![Phone] & "'"

your syntax

"[Phone]= " & Me![Phone]

is only valid for a Field defined as a Number.

Linq ;0)>