Findfirst and edit record (string vs Single)

  I am Trying to use findfirst to edit a record where the fields  are text , can't seam to get it to work ,
  but if i change the fields to numbers it works perfect  
  have no idea what i am doing wrong
Dim db As DAO.Database
          Dim rs As DAO.Recordset
          Set db = CurrentDb
               Set rs = db.OpenRecordset("parts", dbOpenDynaset)
               With rs
                    .FindFirst "[text]=" & Form.text1
                  If Not .NoMatch Then
                       End If
                     MsgBox "record not found"
                  End If
                End With
       Set rs = Nothing

Open in new window

Who is Participating?
Rey Obrero (Capricorn1)Connect With a Mentor Commented:
do a compact and repair

do a Debug>compile
clear errors

open your references see if you have MISSSING
if not unchecked one of the reference click OK
open the references and check the one that you unchecked ( refresh the references)
Hi darkprowler,

try  .FindFirst "[text]='" & Form.text1 & "'"

Good Luck!

Rey Obrero (Capricorn1)Commented:

                   .FindFirst "[text]='" & Me.text1 &"'"
darkprowlerAuthor Commented:
hi Guys
sorry but that don't work i get an  error  3077  syntax error (missing operator) in both you cases
it is strange if i use it where the data type of the fields is set to number it works  but not when they are set to text
.FindFirst "[text]='" & Forms.Formname.text1 & "'"
Substitute Formname with the name of the form.
Do you have a field in the table called Text?
If so maybe change the name of the field.
If not replace text with the name of the field
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.