Resolved....cmd button click event

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 :confused: :confused:

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

VB Code:

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

Its ok, I managed to resolve it

Thanks
;) ;) ;) ;)

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

Thanks for replying