I have a 2000 database running with Access 2007. I have several forms that use a number of combo boxes. All the combo boxes had a rowsource of a table in error (for example a customer table). They should have had the field selected. For example, the CustName control should list the names from the customer file. The CustState should list the states, etc. Instead every dropdown listed all the customer numbers since that was the first column in the table.
I zipped the database and transferred it from the client site to my home/office computer. I modified the forms to correct the combo boxes to list only the appropriate columns from the Customer table. Tested and worked fine. Then I zipped it and sent it back to the client's computer.
When I tested it on the client's computer, I got some very strange results.
1. If I test any combo box dropdown, nothing changed... it still listed just the customer numbers.
2. I open the form in design mode, changed something insignificant, saved it... no change.
3. I open the form in design mode, edit the rowsource for some of the controls, one at a time, to open the query design window, DIDN'T CHANGE ANYTHING, JUST SAVED IT AS IS, saved the form and WALLAH it worked for those controls. The other controls still didn't change.
4. I had to do this for every combo box control to make it work.
Any ideas why I had to go through these steps and how can I correct it?
Thanks, Eddie