Run existing code from new click event? 1

[merlynsdad]

Is it possible, without changing the name of an existing sub which does NOT run from a click event, to run that sub from a new click event?

If the square peg won't fit in the round hole, sand off the corners.

 

[SkipVought]

Yes.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[merlynsdad]

How?

If the square peg won't fit in the round hole, sand off the corners.

 

[dhookom]

merlynsdad,
Do you have any sample code you would suggest for us to work with? Give us an example and someone will help. What is at least the name of your existing sub and how about the name of the clicked control?

Duane
Hook'D on Access
MS Access MVP

 

[MajP]

Private sub someNewControl_click()
myOldSub
end sub

private sub myOldSub()
'code
end sub

 

[merlynsdad]

The existing sub is named Public Sub cmdLogon_AppendUserInfo(). The new click event is named Public Sub btnRunAppendDatabase_click().

If the square peg won't fit in the round hole, sand off the corners.

 

[dhookom]

merlynsdad,
Any comment on your attempt to implement MajP's suggestion? He gave you the correct answer to your question so I would expect you to at least try it and report back with the results and/or questions.

Duane
Hook'D on Access
MS Access MVP

 

[SkipVought]

I think he expects merlyn.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[merlynsdad]

Sorry, I'm in training all day for something else, and haven't had a chance to do anything on this.

If the square peg won't fit in the round hole, sand off the corners.