Original Macro to run

[sooner]

I updated a data entry form and deleted the old data entry form. However, I
did keep the same form name. A Macro was tied to the old data entry form
which displays a warning MsgBox when inputting a social security security
number which already exits on existing table. When I test the new data entry
form by using an existing SSN the warning message box does not work. The
original macro still exists and the macro design should be fine because it
worked before.

 

[Jeanette Cunningham]

Hi sooner,
open the macro in design view.
Carefully check each part of the macro to see if it has the name of a form
somewhere in it.
If it does, change the form's name to the new form.
Have you tied the macro to your new form in the same way it was tied to the
old form?
Are you using Access 2007?


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

 

[sooner]

The macro does have the form name in it and I used the same form name when I
created the new form. After I created the new form, I deleted the old form,
and renamed the form the same (original) name. I am not sure how the
original one was "tied" to the old form. I was hoping you may have some
suggestion as to how I can link it, since I can't remember how I linked it
over 9 years ago. Thanks for your help.

 

[Steve Schapel]

Sooner,

Macros are related to Events. For example the Click event of a command
button, or the Open event of the form. To make it work, the name of the
macro is entered into the event property in design view of the form.
Using the examples above, that would be the 'On Click' property of the
command button, or the 'On Open' property of the form. So if you can
figure out *when* you want your macro to run, this will determine which
event property to assign the macro to.

The above pre-supposes you are not using Access 2007... whereas the
above is true for Access 2007, there are also other options as well.