I am writing a program in VB6 with SQL7 as database. I'm using ADODC. What I want to know is: What is the easiest or most practical way to filter data from a database. My program involves different clients and claim numbers and the end user needs to see data just for a particular client or claim number at any given time. For example, after they log in they choose which client they want to use and from that point on in the program, only that client's data should be viewable. Can anyone help?

Eddie