Combo Box

  • Thread starter Thread starter Sharon
  • Start date Start date
S

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.
 
The row source contains the name of the correct table.
However, it is not pulling from the right column of that
table.
Click to expand...

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.
 
Back
Top