MYLim
asked on
ADO Find Method how to
My Records
========
Field1 , Field2 , Field3
A - 1 - 1
A - 1 - 2
A - 1 - 3
My Code = Rs.Find Condition1
and fail to like :
Rs.Find Condition1 and Condition2 and Condition3 ?
so,How do i Find Row2 ( Values = A,1,2) and let my recordset Position point to row 2 ?
========
Field1 , Field2 , Field3
A - 1 - 1
A - 1 - 2
A - 1 - 3
My Code = Rs.Find Condition1
and fail to like :
Rs.Find Condition1 and Condition2 and Condition3 ?
so,How do i Find Row2 ( Values = A,1,2) and let my recordset Position point to row 2 ?
sorry ignore my previous post,
Find doesnt support multi column search
Find doesnt support multi column search
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
RS.Find "Field1='A' and Field2=1 and Field3=2"