Single Item in ComboBox ?

  • Thread starter Thread starter Jay Wilson
  • Start date Start date
J

Jay Wilson

I have 2 comboboxes. Depending on what I select in ComboBox1 determines
what information will be in ComboBox2. I have this working with no issue.
What I would like to do is if ComboBox2 only has 1 item to select from, I
want ComboBox2 to use that Value with out me having to type anything.

I thought I could add some code to the OnEnter event that would check the
index value of ComboBox2 to see of only 1 item exists and then do the
following, but it doesn't work. What am I doing wrong?

Me.ComboBox2.Value = Me.ComboBox2.Column(0)

Thanks
 
Try this to set the combo box to the first item in the list:

Me.ComboBox2.Value = Me.ComboBox2.ItemData(0)
 
Back
Top