FiveTech Support Forums

Hi,

I'm convering my programs from DBF to ADO.
I have also a find thad the user can find a record in a list with criteria on more than one field.
With DBF I could do a locate for FIELD1 =.. .and. FIELD2=...
How can I do this with ADO on a recordset.

According to the info of the FIND-methode I can only specify 1 field.

Required. The column name, comparison operator, and value to use in the search.
Examples:

"Country='Norway'"
"Date>#7/22/97#"
"Country LIKE N*"

Note: This method does not support multi-column searches (AND or OR)

I don't want to use the filter-property, because I want to show everything. I only want to go to that record.
I also looking for a replacement for a locate next...

I thought maybe running a second recordset with a query, and remembering the ID-number, a jump in my first recordset to that ID. When I to a 'Find Next', I jump to the second one.
But it would be easyier, just with something like FIND...

Marc Vanzegbroeck wrote:I don't want to use the filter-property, because I want to show everything. I only want to go to that record.
I also looking for a replacement for a locate next...

I thought maybe running a second recordset with a query, and remembering the ID-number, a jump in my first recordset to that ID. When I to a 'Find Next', I jump to the second one.
But it would be easyier, just with something like FIND...

Can't you use the same technique using filters?

EMG

Enrico Maria Giordano wrote:
Can't you use the same technique using filters?
EMG

Indeed, I will try it.