[RESOLVED] maybe im asking the wrong questions ...

[Red_Dragon_X]

Hey everyone, I have posted a couple of threads on how to use a DBList or a ListView control to do what i want, but i havent quite got it figured out yet, so let me try a more generalized question:

I have a DB with a whole slew of information for each record. My goal is to have a search function to query the DB and display all results matching that search. (this part i have working fine).

After displaying all records that match that criteria if i were to click on one of the listed results i want to have it open a new form with all the fields from that record displayed into text boxes on that form.

My issue is that i need a few fields to display in the list of records that matched the search, to differentiate between the 2 "John Doe" records that it pulls up from a search of people in Florida.

I cant use a DBList for this becuase i can only show one field, so if i used F_Name i would see 2 listings for "John" with no other info to help me select which one i need. But i can get it to populate the fields from that record into the textboxes on the next form once i select that record from the list.

So i have been working with ListView cause i can display as many fields as i can fit from that record in the actual list so that i can see that "John Doe" (1) is in tampa, and "john doe"(2) is in Miami. But i cant figure out how to make the listview control figure out that i clicked on a record and then go back to that record to get the info i need.

Maybe im going about this the wrong way and there is another control that will give me the best of both worlds, if not; im at a complete loss here. Can some one please suggest to me a way that i can get this done?

Any ideas or comments will help me out a great deal at this point !! Thanks everyone !

--Also, i am using VB6 for this project.