Combo box doesn't allow to select from listed items.

K

kkit

Hi all,

Below are some of the properties for my Combo box.

Control Source: =[tblSuppliers]![SupplierID]
Row Source Type: Table/Query
Row Source: tbl[Suppliers]

The problem is while running the form I can see all desired values
(Supplier Names) in the drop down list but I can't select. When I I
put mouse over any of the values and click to select nothing happens.
Have I messed up any of the property?

Regards,
Krishna
 
B

BruceM

Does your row source include the SupplierID field? If so, it needs to be
the bound column (combo box properties). Typically you would set the bound
column to 1, the column count to 2, and the column widths to 0;1" (or
whatever you need for the second number). To check the row source click the
three dots next to that item in the combo box property sheet.
 
Top