Problem with form after update

[denileigh]

I was having trouble converting our database from 2000 to 2010 so I created a new database in 2010 format and imported everything. All seems to be working fine EXCEPT....there is one form that has one of the drop down boxes not working.

The first drop down where you select the job number works fine.
The next where you choose the customer works fine.
The third where you choose the contact isn't working. You can see the contacts in the list however....it won't allow any selection to be made.

Please help! Thanks in advance!

Thanks,
Dianne

 

[boblarson]

The third where you choose the contact isn't working. You can see the contacts in the list however....it won't allow any selection to be made.

Make sure the Locked property of that combo is not set to YES and also make sure that the field it is bound to (what is listed in the control source) is something that can be updated. A formula cannot be updated, a calculated field cannot be updated, etc.

 

[denileigh]

The column is populated with the customer id (auto generated) and customer name. The ID number is supposed to store itself in a separate table. It was working a-ok prior to me upgrading the database from Access 2000 to Access 2010. UGH

 

[boblarson]

I don't know then. If you can post a copy of the database (with bogus data, not real), I can take a look when I get home (don't have 2010 here) and see if I can spot it. I can usually find the problem fairly quickly if I can see and touch it.

You would need to first run COMPACT AND REPAIR and then after that is done, right click on the file and select SEND TO > COMPRESSED FOLDER to zip it up and then post the zip file. The final zip file has to be at, or under, 2Mb (which should be possible if you remember to compact and repair first and then zip).