As I continue to revise my new client’s code I get the feeling that I am busy doing nothing. I continue to simplify the Access code. However the more I do, the more I find there is left to do.
But I have found the philosophy of Access 2007. It is load sub-forms and then load the form. This is backwards from my thinking, but it is what it is. So where in VBA I could consolidate my forms into one. In here the one main form and it’s two sub-forms must be replicated and customized for their respective purposes.
That makes it easier to test each and hopefully soon all the errors will be gone and it will be just cosmetic changes I need to make. But until then I will continue to be busy doing nothing.