Visablity of feilds on continuious forum (1 Viewer)

swingline

Member
Local time
Today, 17:48
Joined
Feb 18, 2020
Messages
51
I have a continuious form that I would like to change the visablity of one of the fields. Initatally I attempted to put this in on Load, but that sets every record to false on load if the dlookup is true. On current works, some what, meaning when I click on that record where the dlookup is true, then the visablity is set to false as exspected.

I guess my question is, how can a just change the visability for one record on a continuious form?

Code:
Private Sub Form_Current()
If DLookup("TaskNumber", "CompletedTask", "TaskNumber =" & [TaskNumber]) Then
Me.Iterations.Visible = False
Else
Me.Iterations.Visible = True
End If
End Sub
 

Minty

AWF VIP
Local time
Today, 14:48
Joined
Jul 26, 2013
Messages
10,355
Conditional formatting is really the only route and you probably still need to get clever with hidden boxes and the current event.
 

Ranman256

Well-known member
Local time
Today, 10:48
Joined
Apr 9, 2015
Messages
4,339
in continuous form ALL boxes on EVERY RECORD w that name are visible (or not) at the same time.
you cant have 1 line visible and the next not.
 

Users who are viewing this thread

Top Bottom