Search By Feature

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
 
R

RonaldoOneNil

Number fields do not have quotes around
rs.Findfirst "[" & Me.[SearchBy] & "] = " & Me![SearchFor]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pull Down Coding Not Working Well 4
One combo updates another comob, but need all records listed. 5
error on form1/form2 lookup 2
Error in my Search By - Search For Combo Boxes 3
2nd search box not sort properly after using 1st search box 1
Runtime error '3077': , single & double quote 1
son't want to overwrite source record after combo box selection 4
Search last name and first name combo box 7

Top