value of a combobox

[Guest]

I have three different bound comboboxes on a form. The
RowSource are based on three different tables.

I find puzzling is than when I open the form at new
record one of the combobox has a value of 0 (zero) while
the others have a value of Null. I cannot figure why
this should be the case. I am writing a statement that
depends on the initial value of the combobox thus needs
to understand how the values are established.

Is there any explaination or condition that would cause
the values to differ?

Thanks

 

[Ken Snell]

Check the Default Value setting in the field in the table...likely it's set
for 0 in that one combo box, and is "empty" for the other two.

 

[Ken Snell]

My reply left out that the field you need to check is the one to which a
combo box is bound. (the name in the control source for the combo box)