?
Solved

default value of combo box

Posted on 2011-03-17
2
Medium Priority
?
199 Views
Last Modified: 2012-06-21
Experts, I have the following rowsource for an unbound value list combobox:
-1;Yes;0;No
bound = 1
Column count = 2
widths = 0

I need it to default to No.
I have put =No ="No" = 0 but it does not default

What is the problem?  
thank you
0
Comment
Question by:pdvsa
2 Comments
 
LVL 120

Accepted Solution

by:
Rey Obrero (Capricorn1) earned 2000 total points
ID: 35156882
in the load event of the form, set the default value

private sub form_load()

me.combo.value=me.combo.itemdata(1)

end sub
0
 

Author Comment

by:pdvsa
ID: 35156905
worked like a charm.  thank you...
0

Featured Post

Prep for the ITIL® Foundation Certification Exam

December’s Course of the Month is now available! Enroll to learn ITIL® Foundation best practices for delivering IT services effectively and efficiently.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple.  The final solution for this task involved creating a custom text parser and then reading…
Windows Explorer let you handle zip folders nearly as any other folder: Copy, move, change, and delete, etc. In VBA you can also handle normal files and folders, but zip folders takes a little more - and that you'll find here.
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
Suggested Courses

807 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question