i think that this is what you are looking for???...
You can call any public function or sub procedure from within any other procedure.
You can call any private function or sub procedure from within any other procedure within the same module as the prodedure that you wish to call.
You do this simply by writing something like:
Call ProcedureName
For instance, if you would like the code within the Command1_Click event to execute when the Text1_AfterUpdate event occurs, simply write:
Call Command1_Click
within the Text1_AfterUpdate code. You can actually leave out the word 'Call', but I recommend leaving it there.
Does this answer your question?
Darrin@CB69