Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2003
    Location
    Belgium
    Posts
    42

    Unanswered: "Recordset.find" - problem...

    Hi,

    How do you define the criterium in recordset.find?

    I open a recordset and then I try to find 2 things:
    rs.Find "A=True AND B=False"
    This code returns an error.


    However, when I try to find it seperatly, it does work (so I'm sure that my variables are spelled well):
    rs.Find "A=True" => no error
    rs.Find "B=True" => no error

    Isn't it possible to combine those two? I can't find anything in the help files about about the syntax of that criterium... Little help pleazz,

    Greetz,

    Koen

  2. #2
    Join Date
    Nov 2003
    Location
    Netherlands
    Posts
    85

    Re: "Recordset.find" - problem...

    Originally posted by MrData
    Hi,

    How do you define the criterium in recordset.find?

    I open a recordset and then I try to find 2 things:
    rs.Find "A=True AND B=False"
    This code returns an error.


    However, when I try to find it seperatly, it does work (so I'm sure that my variables are spelled well):
    rs.Find "A=True" => no error
    rs.Find "B=True" => no error

    Isn't it possible to combine those two? I can't find anything in the help files about about the syntax of that criterium... Little help pleazz,

    Greetz,



    Try this

    dim stcriteria as string

    stcriteria ="A=True AND B=False"
    rs.Find stcriteria



    Koen

Posting Permissions

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