Resolved....cmd button click event

[holly]

Does anyone know how to stop a user from clicking a command
button without litterally disabling the button

i.e a user clicks a cmd but. the results get printed and if the click
the button again the results are printed again..

Thanks for your help

[swatty]

You could hold a var with value of printed or not, act accordingly

Option Explicit
Private bPrinted As Boolean
 
Private Sub Command1_Click()
   If Not bPrinted Then
      MsgBox "printed"
      bPrinted = True
   End If
End Sub

[holly]

Its ok, I managed to resolve it

Thanks

[holly]

Thanks Swatty, You're example lools better than my solution..I think
I will try yours

Thanks for replying