I have a problem that I am sure is fairly simple to fix but for some reason I can't figure out. I opened a form in my access program and then switched from the 'Form View' to the 'Datasheet View' by selecting View > Datasheet View on the menu bar. I sorted the datasheet view by one of the columns and then deleted a few rows. I then returned to the form view and everything was fine. I later tried switching back to datasheet view and noticed that the datasheet view option was disabled. I reenabled the datasheet view by switching to design view on the form, accessing the forms properties and then allowing the datasheet view on the forms properties. This enabled the datasheet view option but now the datasheet list is empty. There is definitely data there but for some reason it does not appear on the dataview. I may have previously set a filter on the dataview but I can't figure out how to unfilter the grid because the filter option on the toolbar is disabled. The odd thing however is that only one cell is now displayed on the datagrid versus the many columns that I know exist and were previously displayed. Can someone please help me figure out how I can view the data back on the dataview.
Make sure you take regular backups so you can restore your files back to a time you choose.
Create a new form and copy the objects across? Should fix it if there is some corruption in the form.
How big is the form? Would that be a big undertaking?
Other things you can try:
Restore the database from a backup, import the old form into the new database if needed.
Check all the form properties for something amiss.
Check the menus and try Remove Filter and such.
I can't think of anything else that could do that.