Comb box won't update its value (remains blank)

  • Thread starter Thread starter PaulSchrum
  • Start date Start date
P

PaulSchrum

I am using Access 2007 in 2002/2003 mode on Vista.

I have added a combo box to a form using the wizard which looks up its
values in a table.

When I tried to test it just now, the drop down has the correct
values, but the value I select does not appear in the unexpanded combo
box. It just stays blank.

The table is linked from another database. The form is one I am using
as a dialog box with no control source.

Can anyone help me figure out why the combo box won't update its value
(or maybe its not displaying its value).

Thanks.

- Paul Schrum
 
If your combo has more than one column,

check the "bound column" property in the data tab. Does it state which
column you want to bind

check the properties in the format tab. Check how many columns are being
shown and what the widths are.
 
If your combo has more than one column,

check the "bound column" property in the data tab. Does it state which
column you want to bind

check the properties in the format tab. Check how many columns are being
shown and what the widths are.
Click to expand...

The combo box has two columns. The column widths are 0";1"

The bound column is column 1.

There is a detail which may pertain that I forgot to mention. All
tables and all relationships are created in the attached db via sql.
Usually the combo boxes I have gotten to work (many times before) are
based on relationships set up by the Lookup Wizard. So that is
another difference -- I am trying to do the combo box on a "home made"
relationship.

- Paul
 
Back
Top