Results 1 to 3 of 3

Thread: Finding a Record in MS Access (RESOLVED)

Threaded View

  1. #1

    Thread Starter
    New Member
    Join Date
    Jan 2005
    Posts
    5

    Finding a Record in MS Access (RESOLVED)

    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.
    VB Code:
    1. Public Sub findit()
    2.     Dim txName As String
    3.     txName = "1011"
    4.     Forms![Mold Master].FindRecord "[Mold Tag]=" & txName
    5. End Sub
    I get run-time error 2465 - "Application-defined or object-defined error".
    Last edited by TheTortoise; Feb 9th, 2005 at 12:38 PM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width