I have been searching for an answer to this but have, so far, been unable to find it.
In ACCESS Upon clicking a run button on a form a new form is created, and with it 365 (days) controls are created. Each control is given an on_click event using CreateEventProc.
My problem is that the VBE window is activated and I cannot get rid of it until the end of the procedure (using Application.VBE.MainWindow.Visible = False).
Is there a way to stop the window activating? Like a hide? I have tried Echo but that does not stop it opening.
Please help.