Peculiar Combo Box Appearance (not empty on form)

[Jennifer K.]

I know I am going to be asked why this is happening, but I have not been able
to find an answer on the discussion board.

I have a data entry form with several drop down combo boxes. The combo box
has a list of towns and their associated town/county codes from a lookup
table. Someone can choose a town and the appropriate code is supposed to
populate the table. For example:

Addison 101
Burlington 202
Northfield 1003
Out of State 0
Unknown 9999

Choose Burlington and the table will be populated with 202.

This particular list is used twice, but on the second occasion “Out of
State†is not a valid choice and is not included in the table that the list
is drawn from.

On a different note, ideally, OOS should have a code of 0000, but being a
number field that doesn't seem to be possible.

Anyway the combo boxes I have used show up blank in the form until someone
clicks or tabs for data entry. The combo box with “Out of State†as an option
is already populated in the form with "Out of State" and is not empty.

Can someone please explain why this is happening, and is there a solution
for this problem? Assigning a different code to “Out of State†is not within
my authority to change and, as it is, I suspect someone is not going to like
0000 not being available.

Once again, thank you in advance for your time and assistance with this.
Jennifer

 

[Dirk Goldgar]

I know I am going to be asked why this is happening, but I have not been
able
to find an answer on the discussion board.

I have a data entry form with several drop down combo boxes. The combo box
has a list of towns and their associated town/county codes from a lookup
table. Someone can choose a town and the appropriate code is supposed to
populate the table. For example:

Addison 101
Burlington 202
Northfield 1003
Out of State 0
Unknown 9999

Choose Burlington and the table will be populated with 202.

This particular list is used twice, but on the second occasion “Out of
State†is not a valid choice and is not included in the table that the
list
is drawn from.

On a different note, ideally, OOS should have a code of 0000, but being a
number field that doesn't seem to be possible.

Anyway the combo boxes I have used show up blank in the form until someone
clicks or tabs for data entry. The combo box with “Out of State†as an
option
is already populated in the form with "Out of State" and is not empty.

Can someone please explain why this is happening, and is there a solution
for this problem? Assigning a different code to “Out of State†is not
within
my authority to change and, as it is, I suspect someone is not going to
like
0000 not being available.

My guess is that the combo box that shows "Out of State" by default is bound
to a field that has a DefaultValue property of 0. Check the table design,
and if the field has its Default Value set to 0, remove it.