Hi Everyone,

I'm using one combo box to populate another combobox.  I'm extracting
the data from a word table where column A of the table goes to cb1 and
based on that selection column B of the row in cb1 goes to cb2.

However, I've hit a wall when there is more than one of the same name
in cb1.  I would like to know if it's possible to populate cb2 with the
data of all the rows which match the name?

For example, if in cb1 the name selected is "Kraft Foods" and on the
table in column A there are 3 rows for "Kraft foods" where each row in
column B reads "Mary Biggs, Tanya Heller and Mica Ripa respectively"is
it possible  for cb2 to pull data from column B of the table for each
name  matching the name in cb1?

company          name
Kraft Foods       Mary Biggs
Kraft Foods     Tanya Heller
Kraft Foods       Mica Ripa

At the present what it's doing is populating cb1 with 3 Kraft Foods and
in cb2 pulling the name in column B for the row based on which "Kraft
Foods" you select in cb1 (it's hard to tell which person I'm selecting
this way)

Also, I would like to populate the table using the data typed in cb1
and cb2 by the user if name is not available.

here's what I have:

Dim sourcedoc As Document, i As Long, myitem As Range, myitem2 As Range
Application.ScreenUpdating = False
Set sourcedoc = Documents.Open(FileName:="C:\Documents and Settings\My
Documents\client.doc")
For i = 2 To sourcedoc.Tables(1).Rows.Count
   Set myitem = sourcedoc.Tables(1).Cell(i, 1).Range
   Set myitem2 = sourcedoc.Tables(1).Cell(i, 2).Range
   myitem.End = myitem.End - 1
   cmb1.AddItem myitem.Text
   cmb2.AddItem  myitem2.Text
  Next i
Application.ScreenUpdating = True
sourcedoc.Close SaveChanges:=wdDoNotSaveChanges

thank you.