VB Question

[FooKilla]

I have a button that is enable/disable via a dropbox in Access 2000. One problem is when I click the next form the button is re-enabled instead of disabled by default. How do I disable it? I'm using the following code:

Private Sub SUR_Change()
If SUR.Value = "Yes" Then
SurPrint.Enabled = True
Else
If SUR.Value = "No" Then
SurPrint.Enabled = False
End If
End If
End Sub

SUR is the drop box (yes/no)
SurPrint is the button.

Thanks!!

 

[WannaFly]

in form_load:
SurPrint.enabled = false