Hello all,
I have a combox which selects 3 values i.e. 1 for patient is alive, 0 for patient is dead and 9 for unknown.
I have some sub fields (made of textboxes or comboboxes)
which should only appear if vital status= 0 is selected.
for instance the deceased date, cause of death and so on should appear.
I used a code like
Private Sub cboVStatus_DropButtonClick()
If Me.cboVStatus.Value = 0 Then
Me.cboCauseTumor.Visible = False
Me.txtDthdat.Visible = False
Me.txtTumTyp.Visible = False
Else If
If Me.cboVStatus.Value = 1 Then
Me.cboCauseTumor.Visible = True
Me.txtDthdat.Visible.Visible = True
Me.txtTumTyp.Visible = True
Else If
If Me.cboVStatus.Value = 9 Then
Me.cboCauseTumor.Visible = False
Me.txtDthdat.Visible.Visible = False
Me.txtTumTyp.Visible = False
End If
End Sub
any help?