Good afternoon all
I've inherited an Access dB and have been asked to write some code etc to perform a few relatively simple tasks, the problem is the previous dB owner hasn't used any sort of Naming convention and consequently all the controls and forms etc have spaces in there names I've done some digging around and it seems the solutions I thought I'd found downt work
I'm using the following line of code to open the Form called My Form
DoCmd.OpenForm "MyForm", acNormal, , acFormAdd
Now obviously this only works if I rename the form from My Form to MyForm
Ive tried replacing the space with an Underscore or surrounding the form name as such [My Form]
Any ideas, I'll get onto the remainder once I've got a solution to this
Many Thanks
Zippy483