• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 203
  • Last Modified:

default value of combo box

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
pdvsa
Asked:
pdvsa
1 Solution
 
Rey Obrero (Capricorn1)Commented:
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
 
pdvsaProject financeAuthor Commented:
worked like a charm.  thank you...
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now