Combo Box Issue

[gator]

I have a form based on a table. I dragged a text field onto the form and
changed it to a combo box so that the user could select a value from the
values already in the tables, as well as type a new one in.
column count = 1
bound coulmn = 1
When I goto a new record and drop down the combo box list it shows a number
and not the vendor name. How do I get it to show the name?

 

[KARL DEWEY]

Change column count to two and column widths to 0";1" after adding the
second field to the record source.

 

[gator]

I have tried that but it shows either numbers or blanks as the values when I
drop the list down and when I select one the text box fills with that value.
I can't seem to do anything that will display the text in the list and
display it upon selection...

 

[gator]

I used this method as per microsoft instructions. But, Microsoft does not
explain how to set some of the properties....
Add a list box, combo box, or drop-down list box to a form or data access page

1. In Design view, open a form that is based on a record source (record
source: The underlying source of data for a form, report, or data access
page. In an Access database, it could be a table, query, or SQL statement. In
an Access project, it could be a table, view, SQL statement, or stored
procedure.) that includes the Lookup field, or open a data access page that
is connected to the database that includes the Lookup field.
2. If the field list isn't displayed, click Field List on the Form Design
or Page Design toolbar.
3. Drag the Lookup field from the field list to the form or data access
page. Access automatically creates the lookup list box, combo box, or
drop-down list box.

 

[KARL DEWEY]

Is your combo row source a query or select statement?

 

[gator]

rowsource is the table name and the control source is the table field.

 

[KARL DEWEY]

Is that field of that table a lookup field? If so, then that is the problem.