Default value for Combo Box wont work?

T

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;
 
K

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top