Combo Box Issue


G

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?
 
Ad

Advertisements

K

KARL DEWEY

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

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...
 
G

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.
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top