Quote:
>I'm trying to auomate a process usually performed on a switchboard form. I
>can set the focus on the button's but I need to click the button's from a
>module.
You can execute any public module from one form from within another
form. This includes the code for the click event of the button.
Generally you would make a common public sub and call that same sub
from the Click event of the button, or from the outside:
Public Sub DoWhatever
me.cmdSomeButton.setfocus
msgbox "I'm doing it..."
end sub
From your switchboard:
docmd.openform "yourform"
forms!yourform.DoWhatever
Quote:
>I need it to be visual as well as automatic.
I don't know what "be visual" means.
-- Jim Ferguson, FMS
http://www.*-*-*.com/
Automate Process