blank boxes

[alicia]

i have a form where a combo box is the control source for
3 other boxes, this works fine.
however, every time i start a new record, the combo box is
automatically filled with the first result. i would rather
it be blank if possible.
any one know a code to solve this?
thanks

 

[Allen Browne]

Remove the Default Value property of the combo on the form.

You may also need to remove the Default Value of the field in the table.

 

[Allen Browne]

You say the combo is automatically "filled with the first result" when you
begin creating a new record.

What is the first result? Do you mean the first item in the RowSource?
Does this happen only when you begin creating the new record, or does the
combo have a value as soon as you move to the new record?

Is the combo bound to a field? Did you check the Default Value of the field
in the table?

Is there anything in the BeforeInsert event of your form?