Possible to close VBE from code?

[Dan]

Hello,

In my Access application I dynamically create a form to
open against a table that is linked and is dynamic as well
(as far as columns go). When the function I call to create
the form runs, which also creates sub routines under some
of the fields on the form, the Visual Basic Editor opens
and does not close when the function is complete. I would
like to know how to programatically close the VBE form...

Any clues?

Thanks,

Dan

 

[Joshua A. Booker]

Dan,

Not sure how to close the window, but you could avoid the hassle of using
code to manuplulate other code by building a Light Weight Form that has no
code. Unless your code depends on dynamic the columns too.

If you put the code in a public module and add the function names to the
event properties of each control as the form is dynamically built.

For example, putting "=MyFunction()" in the OnClick event of a control will
call the Public Function MyFunction().

HTH,
Josh