How to set Default Value in CBO?

[TKM]

This shold be very easy but I cnat get it to work. I have a CBO with 4
selections. My control source and name is INSURANCE CONSULTANT, My Default is
blank and I want to set it to the 3rd selection in the CBO which is "Pending"
and the ID field associated with Pending is 9 in my table. I have tried
everything from =[pending], [pending] using the ID 9,
[Forms]![fsubPipelineSummary]![InsuranceConsultant].[DefaultValue] =
"""Pending""", etc. Nothing is working.

CAN ANYONE HELP?

 

[Ofer Cohen]

If the RowSource of the combo include both fields

Select Id, Description From TableName

Make sure that the combo BoundColumn is to the Id field, and then write in
the Default value 9

Setting the default won't update existing records only new ones

 

[SteveM]

The ID field is probably the 'bound' column in your combo so set to the
relevant ID.

Me!InsuranceConsultant = 9

Steve