 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Forms / August 2007How to set Default Value in CBO?
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? 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  SignatureGood Luck BS"D > 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 [quoted text clipped - 5 lines] > > CAN ANYONE HELP? The ID field is probably the 'bound' column in your combo so set to the relevant ID. Me!InsuranceConsultant = 9 Steve > 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 [quoted text clipped - 5 lines] > > CAN ANYONE HELP? |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.