Search a database and display info

[birthjay]

Hello,

I have a table in an Access database that has 3 fields (field1, field2, field3). In VB6, I want to display information from these fields on a form that has an SSTab control. I have two tabs (Tab0, Tab1) with controls called (ctrl01, ctrl02). The information on the Access table is divided into groups. For example, field1 has records that are divided by a heading for each group. Like this:

field2
------------
CITY
boston
atlanta
raleigh
STATE
massachusetts
georgia
north carolina

So...I want to display everything under "CITY" on ctrl01 of Tab0 and everything under "STATE" on crtl02 of Tab1. How do I do this from withing VB6? Note: field1 is a primary key that has sequential numbers 0 thru whatever...


Thanks!

[BodwadUK]

Use the DAO object