CreateForm problem

[Dawn Read]

I have allocated some code to a button which creates a
form with a number of fields depending on a value on the
main form. I have used CreateForm and have then
programmatically writen some code to it. This seems to
work OK but the problem is that the VBA editor flashes up
on the screen as well as the new form before it is
completed. How do I stop this??

Thank

Dawn

 

[Mark Phillipson]

You could try turning the screen echo on or off. i.e.

DoCmd.Echo False, "Creating new form please Wait ..."

Then at the end of your code:

DoCmd.Echo True

--

Cheers
Mark

Free Access/Office Add-Ins at:
http://mphillipson.users.btopenworld.com/

 

[Dawn Read]

Thanks Mark
I've already tried that with no sucess

Dawn