Programatically change a macro

  • Thread starter Thread starter JayTee
  • Start date Start date
J

JayTee

Hi all,
I am using an autoexec macro to open a database, in that macro is a line
that opens a form after the menu has opened to sit in front of the main menu
and informs all users of any changes that may be required to be looked at.
I have to go into the autoexec macro to put the condition of false next to
the line which opens the information form.
Is there a way to do this via a toggle button or something similar so that I
can then simply click the toggle button to show or hide the information form
on start up.
Thanks for any help in advance.

JayTee
 
If you are using a satart up form, then you can add to the "open event" a
modular form that will open and require a response from your end user.
 
Look at the Form_Open() event of the information form.

Enter code similar to below pseudo code:

Private Sub Form_Open()
If YrCondition = False then
docmd.openform "MyInfoForm"
end if
end sub

--
Krgrds,
Perry

System:
Vista/Office Ultimate
VS2005/VSTO2005 SE
 
Back
Top