Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 214
  • Last Modified:

Combobox won't let me select

Hi,

I have a combobox of Value List type which is populated like this in onCurrent event:

Private Sub Form_Current()
    Me.Combo25.AddItem "Occupied"
    Me.Combo25.AddItem "Unoccupied"
End Sub

The problem is that I simply can't select the value. I can't type in the combobox, nothing! Why is that?
0
Yury Merezhkov
Asked:
Yury Merezhkov
  • 4
  • 3
  • 2
1 Solution
 
mbizupCommented:
Double check that the combo box is enabled and it's locked property is set to "No"

That code alone should not have that effect.
0
 
Rey Obrero (Capricorn1)Commented:
Private Sub Form_Current()
    me.combo25.rowsourcetype="Value List"
    me.combo25.rowsource="Occupied;Unoccupied"
End Sub
0
 
Yury MerezhkovDevelopment Team LeadAuthor Commented:
checked. enabled - yes, locked - no.
0
Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

 
Yury MerezhkovDevelopment Team LeadAuthor Commented:
Haha, I had Allow Edits set to No in my form. That was the problem. capricorn1, thanks  for the advice.
0
 
mbizupCommented:
RealSnaD,
> I had Allow Edits set to No in my form.
I think that was closer to my post...
0
 
Yury MerezhkovDevelopment Team LeadAuthor Commented:
Oops, sorry mbizup. I thought the first person who replied was also capricorn1. I'm really running late. That's why. Sorry.
0
 
Rey Obrero (Capricorn1)Commented:
RealSnaD
request to reopen the q from CS
0
 
Yury MerezhkovDevelopment Team LeadAuthor Commented:
mbizup, thanks.
0
 
mbizupCommented:
Glad to help out.  
Thank you and Rey for setting it straight.
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

  • 4
  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now