Re-Enable my Control when condition is met.

[jlig via AccessMonster.com]

I have the following code in my frmCPUpdate1:
-----------------------
Private Sub Form_Current()
If Me.Text17 <> "Z" Then
Command13.Enabled = True
Else
Command13.Enabled = False
End If

End Sub
-----------------------

This works perfectly to gray-out my Email(Command13) button when there is no
data in my Text box (Text17) field.

As I scroll thru the records the Email button goes gray & solid depending on
the content of Text17.

But if I update a records Text17 box, I need the code to re-enable my Email
button right now, without having to close & re-open the form?

I tried requery & refresh, but no change?

Thanks in adavance for your help!
jlig

 

[Rick B]

You would ned to put the same code in your Text17 before update event.

 

[jlig via AccessMonster.com]

Thank-You Rick B!

I was almost ready to give up & try a much longer & messy route.
I kept trying to add more code to the same on_current event
and never realized the event was the Text17 field.

Thanks again!
jlig