enabled update button

[tracktraining]

Hello ALL,

I would like to have my UPDATE button to be enabled when the txtdocid and
txtrev fields have some data in it...... I wrote the code as follows:

If Not IsNull(Me.txtDocID) And Not IsNull(Me.txtRev) Then
Me.UpdateTrain.Enabled = True
End If

When I enter something in both the txtdocid and txtrev, the update button is
not enabled.

Please help.

thanks!

 

[Beetle]

In what event did you put this code?

 

[tracktraining]

This is where the code is:

Private Sub txtRev_GotFocus()

'Enable the Update button if a DocID has been entered in search criteria
and
'a revision has been entered in the Rev. field
If Not IsNull(Me.txtDocID) And Not IsNull(Me.txtRev) Then
Me.UpdateTrain.Enabled = True
End If
End Sub

 

[scott04]

Try putting it in the Form_Current() and in the Afterupdate of txtDocID and
txtRev

 

[tracktraining]

adding the code in the before update event works. thanks for guiding me.