Default value for Combo Box wont work?

[TKM]

My last request was terrible so I thought I would rewrite. I need my combobox
to default to the third word down in my cbo box. That word is "pending". The
number assocaited with it in my table is Field Code ID 9. I put 9 in the
defult value, I put the word "Pending" in there and nothing. The cbo box is
located in a subform. The CBO is based off a query.. This is simple so why
wont it work?

SELECT tlkFieldCodes.FieldCodeID, tlkFieldCodes.FieldCodeDesc FROM
tlkFieldCodes WHERE (((tlkFieldCodes.FieldCodeGroup)="Insurance
Consultants")) ORDER BY tlkFieldCodes.FieldCodeID;

 

[Klatuu]

The Default Value property is only applied when the combo is a bound control
and you create a New record. If you want to show a specific value in a combo,
you need to explicitly populate the combo with a value in the list using the
Bound Column. When you do that depends on how your form works.