ADO Question

[zzfive03]

Is it possible to use the ObjRS.Find to do a search on several items. For example, below I am looking for job to be = 4.
----
objRS.Find "job = 4"
----

Can I search multiple fields? Like:
----
objRS.Find "job = 4 and Name = 5"
----

Can I do a IN search?
----
objRS.Find "job in (4, 5, 6)"
----

Thanks for any help on this.

Mark

 

[jmerencilla]

i think it would be better if you use Filter instead of Find