Changing caption text and hiding buttons

  • Thread starter Thread starter Paul_Russell
  • Start date Start date
P

Paul_Russell

Hello
I've written a fairly simple bit of code to change a form and make th
user of the reports aware that they are updating.
It works just fine without the macro attached, but when I call th
macro in the line afterwards the form fails to update.

Any ideas?

Cheers
Paul

Private Sub ClickYes_Click()

MarketLabel.Caption = "Running Reoprts"
ClickYes.Visible = False
ClickCancel.Visible = False

ReportMacro

Me.Hide

End Su
 
Private Sub ClickYes_Click()

MarketLabel.Caption = "Running Reoprts"
ClickYes.Visible = False
ClickCancel.Visible = False
me.repaint
doEvents
ReportMacro

Me.Hide

End Sub
 
Fantastic.
Unfortunately I have to wait until tommorow morning to get into wor
and try it!

Thanks Tom really appreciate the help

Pau
 
Back
Top