How to set Default Value in CBO?

T

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?
 
O

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
 
S

SteveM

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

Me!InsuranceConsultant = 9

Steve
 

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