Event Procedures

[Little Penny]

Is it possible to modify the on click event procedure of a command
button of another form with a macro\vba command button from another
form? Just like changing the control properties of a form but for an
event procedure.

 

[Mr. B]

Hi, Little Penny.

While I don't think that I have ever attempted to modify code in one
procedure from another one, I would not say that it could not be done.

However, with that said, I would suggest that what I would be doing is
programming for any and all conditions. Programming like this is the proper
way to do what you are wanting to do. You can do things like checking to see
if a certain form is loaded or checking for a certain value in a specific
control and so on.

Try programming your buttons for all possible cases you need it to perform
actions rather that attempting to modify the code itself.

 

[Little Penny]

After reading the replys I have changed my approach. I soory I did't
think of it in the first place

This is why this group is so valuable. It makes you think.


Thanks to all.