In MS Access, how do I find a record using VBA?
I've used the following code to attempt to find the value "1011" in the field "Mold Tag" in the form "Mold Master", but it doesn't work.
I get run-time error 2465 - "Application-defined or object-defined error".VB Code:
Public Sub findit() Dim txName As String txName = "1011" Forms![Mold Master].FindRecord "[Mold Tag]=" & txName End Sub




Reply With Quote