Update a control

[gykiang]

I have a simple event code for toggle button in a single form named "DisplayEXEAGAINST" with control and value to be stored in [DisplayEXEAGAINST] :

Private Sub DisplayEXEAGAINST_Click()
Me.BoxEXE.Visible = IIf(Me.DisplayEXEAGAINST.Value =-1, True, False)
End Sub
-------------------------
Private Sub Form_Current()
Me.BoxEXE.Visible = IIf(Me.DisplayEXEAGAINST.Value =-1, True, False)
End Sub
------------------------

The intention is to hide or unhide the record of Me.BoxEXE in every row independently.

However, after click of the button, the same record in all the rows will change to become the same which is incorrect, i.e. the same record in all the single form be hidden or unhidden.

Appreciate help to correct the error.



Thanks !

[June7]

You said this is a single view form?

Not sure what you mean by 'record of Me.BoxEXE in every row independently'. What is BoxEXE - a list box?

If this is a single view form, why would it show multiple rows?

[gykiang]

Me.BoxEXE is just a Label field.
Every row is a new form.

[June7]

Just hiding a label won't hide an entire row.

I still don't know what you are trying to accomplish.

If you want to provide db for analysis, follow instructions at bottom of my post.

[John_G]

If the form control Me.DisplayEXEAGAINST is not bound to a table field, then its value will be the same for all records the form displays, and therefore the On Current event will always yield the same result (until you change the value of Me.DisplayEXEAGAINST again.