Where is the VBA for a Form Stored - Access Developer Forum


	Back to Access Developer Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Where is the VBA for a Form Stored

Robert Baker

13 months ago

I've got a head scratcher. I've spent hundreds of hours developing a financial database for my personal use. Yesterday I was fixing a problem with how a form is filtered and the longer I worked on it, the more screwed up it became. Finally I decided to revert back to a previous version of the form, so I used External Data > New Data Source > From Database > Access (I back up daily) and got an older copy of the form. Problem is, the form kept repeating the same issues, so when I looked at the VBA behind the reverted form, it was the same VBA that I had just changed. So if a form dated a previous day has today's VBA, where is the VBA being stored? Thanks to anyone that can help with this (it's not urgent; I was able to fix the problem, but I'm just stumped about this!) -- Robert Baker

	Thomas Gonder @Reply 13 months ago
Did you delete the form in your database before importing from a backup? If so, you should get the older version of the form and the VBA too, as it's stored in the .accdb file along with everything else. I do this all the time while developing (and after a big screw up). If that didn't happen then I would suspect some kind of corruption in your .accdb file(s).

	John Davy @Reply 13 months ago
Hi Robert, if you imported only the form, you still have tables, modules, queriies etc from the earlier database. John

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Developer Forum.

Next Unseen

New Feature: Comment Live View