Combo Box - value list is blank!

[adams937]

I have built a form that inputs data into a table. A number of the fields have combo boxes, with the "row source type" set to "value list". When I view the table in datasheet view, the combo boxes function correctly. However, when using the form to input data, these combo boxes show up blank.

Any idea what I'm missing? Seems like a simple option somewhere, but I can't seem to find it.

Thanks!

 

[JamesMcS]

Strange - have you changed any other properties for the combo box? Does it still happen when you create a new combo with the same values, but default everything else?

 

[missinglinq]

A number of the fields have combo boxes, with the "row source type" set to "value list". When I view the table in datasheet view, the combo boxes function correctly. However, when using the form to input data, these combo boxes show up blank.

From your description I'm assuming that these Comboboxes are in the Table itself, rather than being created in the form. You need to provide these lookups as Comboboxes in the Form rather than in the Table.

Read here about the Evils of Lookup Fields in Tables:

http://www.mvps.org/access/lookupfields.htm

Linq ;0)>

 

[JamesMcS]

Well spotted Linq!

 

[adams937]

Thanks for the replies. You're correct, the combo boxes (with value lists) are located in the table and not in the form. After reading the MVPS link, I can see why this generally bad practice. Thanks for the tips... problem solved!

 

[missinglinq]

Glad we could help!

Linq ;0)>