We help IT Professionals succeed at work.
Get Started
Has anyone encountered issues with an Access 2010 Combo Box not functioning correctly?
I have a Bound Combo Box on a Main Form that has it’s Row Source set to a Union Query.
The Bound Column is set to 1. (Primary Key)
The Column Count is set to 4.
The Column Widths are set to 0cm; 5cm; 0cm; 0cm
When I open the Form the Combo Box is completely empty (ie no row data is displayed) even though I know the field it is bound to has a valid Primary Key value assigned.
When I Open the underlying Union Query that shows the correct row data, so I know there isn’t an error there.
The weird thing is that when I go back into design view and change the Column Widths to 1cm; 5cm; 0cm; 0cm then open the Form the Combo Box functions correctly, apart from the fact that it displays the 1st column, the Primary Key value instead of the 2nd column the Description.
I have also created a new blank Form, and inserted the same Combo Box onto it with the Column Widths set to 0cm; 5cm; 0cm; 0cm. In this case the Combo Box functions correctly.
Is it possible that my Main Form has become corrupted in some way that’s why the combo box isn’t displaying properly?
Has anyone else encountered this before?
Is there a way to fix it?
My Main Form has a quite complex design which I would like to avoid having to rebuild!
Any feedback would be appreciated.
The Bound Column is set to 1. (Primary Key)
The Column Count is set to 4.
The Column Widths are set to 0cm; 5cm; 0cm; 0cm
When I open the Form the Combo Box is completely empty (ie no row data is displayed) even though I know the field it is bound to has a valid Primary Key value assigned.
When I Open the underlying Union Query that shows the correct row data, so I know there isn’t an error there.
The weird thing is that when I go back into design view and change the Column Widths to 1cm; 5cm; 0cm; 0cm then open the Form the Combo Box functions correctly, apart from the fact that it displays the 1st column, the Primary Key value instead of the 2nd column the Description.
I have also created a new blank Form, and inserted the same Combo Box onto it with the Column Widths set to 0cm; 5cm; 0cm; 0cm. In this case the Combo Box functions correctly.
Is it possible that my Main Form has become corrupted in some way that’s why the combo box isn’t displaying properly?
Has anyone else encountered this before?
Is there a way to fix it?
My Main Form has a quite complex design which I would like to avoid having to rebuild!
Any feedback would be appreciated.
Why Experts Exchange?
Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.
Jim Murphy
Programmer at Smart IT Solutions
When asked, what has been your best career decision?
Deciding to stick with EE.
Mohamed Asif
Technical Department Head
Being involved with EE helped me to grow personally and professionally.
Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question
Connect with Certified Experts to gain insight and support on specific technology challenges including:
- Troubleshooting
- Research
- Professional Opinions
Did You Know?
We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE