Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2002
    Posts
    168

    Unanswered: Find a record in a recordset

    I am trying to use 'find' method i a recordset. Here is my code :


    strSQL = "[A] = '" & rst1![A] & "'" _
    & " And [B] = '" & rst1![B] & "'" _
    & " And [C] = '" & rst1![C] & "'"
    rst2.find strSQL

    This gives me an error when I try to execute the code. However, when I only the one-criteria variable (e.g. A), it works. Then, I use 'filter' instead and it works fine. Does anyone know why 'find' does not work in this case ?


    Thanks

  2. #2
    Join Date
    Apr 2002
    Location
    Portugal
    Posts
    146
    Milan,


    Have you tried to use the command FindRecord!?

  3. #3
    Join Date
    Apr 2002
    Posts
    168
    Hi Miguel,

    Isn't find record only for DAO ? I am using ADO. The filter works fine for me, it can do the job, I am just curious why by putting several variables in the strSQL, the find does not work.

    Thanks

Posting Permissions

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