please help: run time error 3070 database does not recognize ' ' as valid field name

[merilu]

Please help me.
I'm trying to update a database using code in access and the following error appears : "Run time error 3070 the microsoft access engine does not recognize ' ' as a valid field name or expression.
I'm for sure entering a valid name..
Here is my code.
Thank you!!

Dim db As DAO.Database
Dim rs As Recordset
Dim name As String
Set db = CurrentDb()
Set rs = db.OpenRecordset("info", dbOpenDynaset)
name = InputBox(" ")
rs.FindFirst "company_name = " & name  'here is the problem
 
 

[cactusdata]

Try this:

Dim db As DAO.Database
Dim rs As DAO.Recordset
Dim name As String
 
Set db = CurrentDb()
Set rs = db.OpenRecordset("info", dbOpenDynaset)
 
name = InputBox("Enter Company Name")
If name <> "" Then
    rs.FindFirst "company_name = '" & name & "'"
End If

[merilu]

Cactusdata this helped me a lot, it worked! Thank you!