We just upgraded some of our PCs to MS Office 2010. We have an Access DB that has been used since Access 2000 and prior for over 10 years.
Suddenly, with this upgrade, many of our datasheet view type forms are not working properly.
When you attempt to select any record below the first displayed record and perform an action (we have a button that then opens a separate form based on the record actively highlighted), we get an error message of "You Can't go to the specified record".
Additionally, you can't navigate from one record to the next using the standard MS Access record selector at the bottom of the form.
I imagine this is a simple setting or something that defaulted incorrectly upon installation?