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?
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