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.
Adam HoweAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Dale FyeCommented:
Yes, it is possible that the main form has become corrupted.  When that happens to me, I generally create a new database and import all of the other objects (except the offending form) into the new database.  Then I recreate the corrupt form, from scratch.

You could also try to decompile the application (make a copy of the db or perform the step above before you decompile).  Then decompile the application and recompile.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Nick67Commented:
My Main Form has a quite complex design which I would like to avoid having to rebuild!
Then be pro-active
Create a new form
Copy all the objects off the old form
Copy all the code from the old form
Paste into the new form and new form's module
Set the new form's background and tiling (not much else needs that kind of treatment, I think.

Test

if the problem went to the new form, then you have something REALLY weird going on.
If not you are done after renaming the new form

1cm; 5cm; 0cm; 0cm
Why?  Why pull columns and not display them.
The PK, that makes sense.
The other two, not so much

Highly complex forms get brittle
Learn the signs and what you need to rebuild them when you need to.
Backups.
Previous versions working on the drive where the file resides
Corrupted objects are no fun.

NEVER CHANGE THE DESIGN OF AN OBJECT CREATED WITH A2007+ WITH A2003-
Corruption occurs in short order.
0
Adam HoweAuthor Commented:
Thanks Dale and Nick67 for your responses.
After trying a few options, and going back through some back-ups it seems the only solution was to as Dale suggested and create a new database and recreate the corrupt form, from scratch.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.