Set the Enabled property of the command button to False in the design window.
Create an AfterUpdate event procedure for each of the controls that display data from the worksheet. For example:
Private Sub TextBox1_AfterUpdate()
Me.cmdUpdate.Enabled = True
End Sub
where cmdUpdate is the name of the command button.
Regards, Hans Vogelaar (http://www.eileenslounge.com)