I would not assume anything and check the behavior of the recordset now before assuming corruption. Sometimes data changes that breaks things, usually not if properly designed but sometimes data mysteries happen. That said, with all recovery attempts backup the original and try stuff...
Generally I would try the decompile command line switch on the Front End, compile everything.
If that doesn't work or just to try more stuff all at once to be over it, I would import all objects in each back end and front end to new files. Note sometimes corruption follows objects on import to a new file.
If that doesn't work two solution paths based on 1 data corruption or 2 application corruption.
1) You could try dumping the tables behind the record source of the form to text, creating new tables in a new file and importing the text data and remaining tables. Ultimately you could try this with all tables and not just the suspect ones. I have never had to go down this path but would seem to be the cleanest / most straight forward.
You might not be able to use the dataset as a whole. I have seen in smaller tables things like #Error in fields once or twice... Just manually add correct records and delete the problem ones. According to something I read a long time ago, Access won't tab out of a field with error data... the solution is to leave something holding the tab key down and let it run overnight... Obviously, a locked office or using a local copy on a laptop at home are likely the way to go here. I do not know if the tab not moving is true or if it is true with current versions so if this works, I would like to know. I have not seen it in a really long time.
2) Use the Undocumented SaveAsText and LoadFromText VBA procedures to save out suspect objects to text file and reload them... Again in a clean file importing other objects separately. And again ultimately you could try this with all objects and not just the suspect ones. The intellisense works on those procedures which should be enough documentation or easily found elsewhere if you need more help.
Good luck! And do not forget the old stand by, restore to the last known working version.
