Copying code from one form to Another

[patkeaveney]

Hi

I have added some command buttons to a form and added some extra code behind them.

I want to use the same buttons and code in several other forms within my database.

Is there a simple way for me to be able to do this, as copy and paste only copies the buttons and not the code behind them.

Thanks

 

[reclusivemonkey]

Create the code behind your buttons as Functions, with the context dependent parts as variables in the function calls. You can then call the function with the appropriate variables in. Sorry, not a great explanation, I mean something like

Function myFunction(myVariable as String)
[i]some code here[/i]
End Function

then

Sub CallFunction
Call myFunction(myVariable)
End Sub

wherever you need it.