I'm try to setup a very basic part look up at work. I have a field on a form that has part numbers called "National_Stock_Number" That I want to search through. When I set it all up and run the search I get this:
run time error '3070' The Microsoft Access database engine does not recognize HMCP100R3C as a valid field name or expression.
If I change the search to use the ID number to find things it works fine.
Here is the coding for it all.
Private Sub Search_Click()
If IsNull(Text42) = False Then
Me.Recordset.FindFirst "[National_Stock_Number]=" & Text42
Me!Text42 = Null
If Me.Recordset.NoMatch Then
MsgBox "Error please try again.", vbOKOnly + vbInformation, "Error."
Me!Text42 = Null
End If
End If
End Sub
Any Ideas would be great. Or if someome could point me in the right direction for a super easy tutorial on it, that would also be helpful.