Command Button to execute a Function

[AJOLSON]

I have the following function that I want to execute onclidk using a command
button.
What code will run this (or any function) on click within a command button
Public Function AutoCompact()

CommandBars("Menu Bar"). _
Controls("Tools"). _
Controls("Database utilities"). _
Controls("Compact and repair database..."). _
accDoDefaultAction

End Function

Thanks

 

[RonaldoOneNil]

In the OnClick event of your command button put this

Call AutoCompact