Hey, I have been trying to figure this out for about a day now. And to let you know, I've already googled it. So this is what I'm trying to do...

I have been trying to Select a certain amount of data from my Database.. but I want it to expand the search for my record rather than narrow it..

For Example.....
rs.open "SELECT * from users WHERE toid="&currentID&" and fromid="&CurrentID,Db1,3,3

This narrows the search so that it only selects the records that have toid and fromid = Currentid. This is the problem. I want it to select all the records that have fromid = currentid, and select all the records that have toid = Currentid.

Any Ideas? I'm fresh out. TIA

-Ei0nN

You got to make a big big change in your select statement.;)

Use this...

rs.open "SELECT * from users WHERE toid=" & currentID & " or fromid=" & CurrentID, Db1, 3, 3

Cheers!

_________________________
-Vijay G
Strive for Perfection

Haha! That was fun to ponder for the past day.:D Works like a charm. Thanks gv.
Later

-Ei0nN