Happy New Year!

Recently I was working on a project where I was implementing form spawning so that my client can see at least two different records using two identical forms, one of the actual forms and the other one a spawned version of itself, (a topic I’ve discussed at my SQL Server with Access meetings, click to join the announcement list!). Because the prior developer did not use form spawning, I had to search all instances in control source of all forms to identify references to the original form and replace it with TempVars.

SQL Server Hosting

The project has dozens of forms and thousands of controls, so I created the following code to scan all form record sources for the offending row source and the control source of all controls on the form as well.