Visablity of feilds on continuious forum (1 Viewer)

swingline

Member
Local time
Today, 18:35
Joined
Feb 18, 2020
Messages
49
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, 15:35
Joined
Jul 26, 2013
Messages
7,529
Conditional formatting is really the only route and you probably still need to get clever with hidden boxes and the current event.
 

Ranman256

Registered User.
Local time
Today, 10:35
Joined
Apr 9, 2015
Messages
3,641
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