Search By Feature

  • Thread starter Thread starter Curtis Stevens
  • Start date Start date
C

Curtis Stevens

This code isn't working when I'm doing it with number fields. Works fine
with fields that have text or phone numbers, but not numbers like 1,2,3.

Set rs = Me.Recordset.Clone
rs.Findfirst "[" & Me.[SearchBy] & "] = " & Chr(34) & Me![SearchFor] & Chr(34)
If Not rs.EOF Then Me.Bookmark = rs.Bookmark
Me.SearchFor = Null
 
Number fields do not have quotes around
rs.Findfirst "[" & Me.[SearchBy] & "] = " & Me![SearchFor]
 
Back
Top