List Box Problem

[Needy Soul]

Dear friends, I have a (MS Access 2003) database with a lookup table that has
a Primary Key field (data type is autonumber) and one additional text field
named Manufacturers. I have another table containing a field that uses the
lookup table as a pick list (List Box). However, only the Primary Key field
shows in the drop down menu. How do I set up the List Box such that the
contents of the Manufacturers field shows in the drop down menu?

Thanks in advance!

 

[fredg]

Dear friends, I have a (MS Access 2003) database with a lookup table that has
a Primary Key field (data type is autonumber) and one additional text field
named Manufacturers. I have another table containing a field that uses the
lookup table as a pick list (List Box). However, only the Primary Key field
shows in the drop down menu. How do I set up the List Box such that the
contents of the Manufacturers field shows in the drop down menu?

Thanks in advance!

If you wish the Primary Key field to be saved in the table when an
Item is selected, set the List Box BoundColumn property to 1.
Set the List Box ControlSource to the name of the field in the table.

Set the List Box ColumnCount property to the number of columns
returned by the List Box Rowsource , in your case 2.
Set the List Box ColumnWidths property to something like:
0";1"
which will hide the Primary Key field and display the Manufacturers
field.

 

[Needy Soul]

Thank you so much. Problem solved