Hiding or making visible certain fields within a continuous sub form.

[Ant_Snell]

I have an employee form with an absence details continuous sub form. The absence sub form includes an absent type combo with options like holiday, sickness, TOIL etc. and also Sickness Reason Level 1 combo & Sickness Reason Level 2 cascading combo fields along with other various fields like start date, end date and employee ID fields.
I would like to make the Sickness Reason fields only visible when the absence type is Sickness.
I have done this attaching the following code to the after update property of the absence type combo field:



Private Sub Emp_Absence_Type_AfterUpdate()
If Emp_Absence_Type = "Sickness" Then
SickReason1Combo.Visible = True
SickReason2Combo.Visible = True
Else
SickReason1Combo.Visible = False
SickReason2Combo.Visible = False
End If
End Sub

This works fine however it affects the full record set of the continuous form rather than just the affected record e.g. even if say “holiday” is selected on a different record it makes the sickness reason fields visible or vice versa if “holiday” on the current record is selected it hides the sickness reason on other records even if the reason is sickness.
How can I show the sickness reason fields only on the current record without affecting other records in the sub form?

[ranman256]

That how continuous form works.
so either use a single record form to hide it,
or
dont hide it. If they’re not sick, then the box is blank.

[Ant_Snell]

Ranman256, OK Thanks, it looks like its back to the drawing board for me then re design.

[Gicu]

You can try conditional formatting:

https://answers.microsoft.com/en-us/...e-85fba957c873
https://answers.microsoft.com/en-us/...6-26b09470c55d

Cheers,

[Ant_Snell]

Good idea!, I think that should do it (thinking outside the box!) Thanks