Re: Disable Button If

Tech-Archive recommends: Fix windows errors by optimizing your registry

yes,

you can use the form current event to test values:

'~~~~~~~~~~~
Private Sub Form_Current()
dim mBoo as boolean
mBoo = true
if me.controlname = somevalue then mBoo = false
if me.fieldname = somevalue then mBoo = false
if someOthercondition then mBoo = false
'etc
me.CommandButton_controlname.enabled = mBoo
End Sub
'~~~~~~~~~~~

you can use the AfterUpdate event of particular control to switch the enabled status during form entry

Warm Regards,
Crystal
*
(: have an awesome day :)
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*



Supe wrote:
Is there a way to Disbable a Button if there is any information in any of a number of different fields?
.

Quantcast