Combo box not responsive

  • Thread starter Thread starter Fredrated
  • Start date Start date
F

Fredrated

I have created hundreds of combo box controls, but I have never encountered
this.
When I click on the combo box it opens up, but it will not let me type
anything into the box, and it will not populate the box when I click on a
selection!

The box is unbound and control source is empty
the row source is
SELECT Project.ProjectID, Project.ProjectNumber, Project.TaskNo
FROM Project
ORDER BY Project.ProjectNumber, Project.TaskNo;

I only want the users to see the projectnumber and taskno, so the bound
column is 1 and the column widths are 0";0.6";0.1"
column count is 3
Limit to list is yes
enabled is yes and locked is no
The form is continous, but when I change to single form nothing changes
I have repaired/compacted to no effect
I added another combo and it acts the same

I am using access 2002 sp3

Any ideas what may be causing this?

Thanks in advance for any help, if I solve it I will post solution here.

Fred
 
I have now opened a form with a working combo box and copied the combo box
into a blank form. In the new, blank form the combo box is broken.

What gives?
 
Is the form's AllowEdits property set to Yes? It must be Yes if you want to
type into or select an item from a combobox.
 
Back
Top