Solved

Combobox won't let me select

Posted on 2006-11-03
9
194 Views
Last Modified: 2012-06-21
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
Comment
Question by:RealSnaD
  • 4
  • 3
  • 2
9 Comments
 
LVL 61

Accepted Solution

by:
mbizup earned 500 total points
ID: 17868350
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
 
LVL 119

Expert Comment

by:Rey Obrero
ID: 17868357
Private Sub Form_Current()
    me.combo25.rowsourcetype="Value List"
    me.combo25.rowsource="Occupied;Unoccupied"
End Sub
0
 
LVL 7

Author Comment

by:RealSnaD
ID: 17868358
checked. enabled - yes, locked - no.
0
 
LVL 7

Author Comment

by:RealSnaD
ID: 17868427
Haha, I had Allow Edits set to No in my form. That was the problem. capricorn1, thanks  for the advice.
0
IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

 
LVL 61

Expert Comment

by:mbizup
ID: 17868465
RealSnaD,
> I had Allow Edits set to No in my form.
I think that was closer to my post...
0
 
LVL 7

Author Comment

by:RealSnaD
ID: 17868483
Oops, sorry mbizup. I thought the first person who replied was also capricorn1. I'm really running late. That's why. Sorry.
0
 
LVL 119

Expert Comment

by:Rey Obrero
ID: 17868534
RealSnaD
request to reopen the q from CS
0
 
LVL 7

Author Comment

by:RealSnaD
ID: 17873949
mbizup, thanks.
0
 
LVL 61

Expert Comment

by:mbizup
ID: 17873954
Glad to help out.  
Thank you and Rey for setting it straight.
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

743 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now