Results 1 to 4 of 4
  1. #1
    Join Date
    Nov 2004
    Posts
    35

    Unanswered: I need some help, please

    I'm working on a form which is linked to a query on one table. I am using the form's recordsetclone. One of the fields [parents] contains two names and I have inserted a button to allow the user to select one of these names. I simply parse the names and put them into a listbox on another form. As soon as the listbox is clicked, the user returns to the main form with the searchTxt [Full Name] = "A N Other" and I'm using rst.FindFirst but it doesn't move to that record - it goes to the first record.

    Can anyone shed any light, please?
    Marion

  2. #2
    Join Date
    Feb 2005
    Posts
    20
    try it this way

    rst.findfirst "[Full Name]='A N Other'"

    don't forget the ' inside the criteria expression

  3. #3
    Join Date
    Nov 2004
    Posts
    35

    ' instead of "

    Yes, I had tried that, with the same results. However, the searchTxt returns as [Full Name]="A N Other". Perhaps it should be "[Full Name]='A N Other'" (enclosed by quotes). I shall experiment some more.

    Thanks
    Marion

  4. #4
    Join Date
    Nov 2004
    Posts
    35

    Got it, thanks

    Oh dear, I've spotted it ... and it's a bad one. I need to reformat the string to match what is actually contained in the table. That is, I was searching for something that didn't exist. Told you it was a bad one.

    Thanks for your help
    Marion

Posting Permissions

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