Control button visible based on field value in record 2

[jpkeller55]

I have a form with continuous records that are shown. I would like to put a command button in the detail section of the form to only be visible if the value of one of the fields is a certain value (Me!Text54 = 12).This is what I have on Form Open:

If Me!Text54 = 12 Then
Me.CSinfo.Visible = True
Else
Me.CSinfo.Visible = False
End If

This worked in making the cmd button (CSinfo) disappear, but it has disappeared in all the records and does not show up on the records where Text54 = 12. Any help??

Thanks

 

[VRoscioli]

You need to also run this code in the OnCurrent event of the form so that it runs when you change records.


-V

 

[jpkeller55]

That worked for me...Thanks!