I have an application that I have inherited. It works with 2007 and SQL Server 2008. I'm having trouble with some open recordsets and some of the forms that are being used. A recordset will be opened and then a "with" statement added for the form which fires off another recordset to be opened with the same name. This obviously fails.
I have tried multiple names for the recordsets wih various errors all pointing to connections and recordsets being opened and not closed properly or closed and then being unable te reopen them. There are too many to track down at the current time.
Access has a mind of it's own when it comes to loading forms with multiple subforms. The order of events is predictable, but I have watched it go a different route on multiple occasions when nothing significant has been changed.
Here's my question. Is it possible to prevent any/all functions and/or subs from running until the pleasantries have been exchanged between the forms and Access? Does this make sense? Basically, I don't want anything to run until all of my forms are in proper position to actually get the data that I want to send them.
TIA,