objects in macros

[Guest]

Is there a way that I can have a condition in a macro that refers to whether
an object is open. I want a macro to continue even if an object referred to
in the macro is closed, however at present the Macro stops and throws up an
error message. The simple way to do this seemed to me to be to make the
action conditional on the object (a form) being open. Unfortunately this is
beyond me.

 

[Guest]

Insert an openform before the line you try to access any controls on the form.

 

[Guest]

That would seem to be fine but I don't want to open the form if it is closed.
I want the Macro to continue running with the subsequent actions. Sorry If
I didn't make this clear.

 

[Pat Hartman]

Switch to VBA, you'll have more control. You can use the wizard to convert
your existing macro so you don't have to recode the process from scratch.

 

[Guest]

Well.. that would get you around the macro crashing.

I'm on a machine with access 2000, but I seem to remember there being an
isloaded property for forms in newer versions. Perhaps you can use that in
the condition.

I typically do little in macros, and run everything from a VBA script. .. so
that's about as much as I can think of.