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.
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.
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.