Combo Box

[Sharon]

The row source contains the name of the correct table.
However, it is not pulling from the right column of that
table. For instance:

1st Table

column 1 - Name
column 2 - Address
column 3 - City
column 4 - State
column 5 - Zip
column 6 - Phone #
column 7 - E-mail Address


2nd Table

Name: The row source says "1st Table" and the drop down
box shows the names.


Address:

City

Phone # etc.: The row source here also is "1st Table"
but the drop down list shows the "Names" instead of the
phone numbers here.

Thanks so much for your patience and time. I don't know
what I would do without this type of newsgroup. Thanks.

 

[John Vinson]

The row source contains the name of the correct table.
However, it is not pulling from the right column of that
table.

Create a Query based on the table, pulling the fields that you want to
see; set the Sort order of this query to control the order in which
you wish to see them - and use this Query as the Rowsource.