How to hide field/s depending upon the value in other fields of same form in Access

[Yousaf Shah]

Hello everybody
Actually I am a beginner with MS Access and want to make my own data base for my patients (as I am Surgeon by profession). I explain you my new query...
Suppose we have two bound combo boxes, "PositiveGPE_Finding" and "Lymphnode_Gp" respectively, in same form named "History". "PositiveGPE_Finding" combo box have value list with Multiple Selection enabled and Values; Pallor, Jaundice, Cyanosis, Lymph Nodes. Combo box "Lymphnode_Gp" has its own values. Is it possible that "Lymphnode_Gp" combo box is only enabled when 'Lmph Node' value is checked in "PositiveGPE_Finding" combo box.....
I have tried using 'ItemData' and 'Selected' properties of combo box but could not succeed....

I tried this code in the AfterUpdate()event of cbo PositiveGPE_Findings but it didn't work as well...

Private Sub PositiveGPE_Findings_AfterUpdate()
  Dim varItem As Variant
  Dim ctl As Control
 
  Set ctl = Me![PositiveGPE_Findings]
 
  If ctl.ItemsSelected.Count = 0 Then Exit Sub
 
  For Each varItem In ctl.ItemsSelected
    Me![Lymphnode_GP].Enabled = (ctl.ItemData(varItem) = "Lymph Node")
  Next
End Sub

Can you help me with this....???

[TheSmileyCoder]

The ItemsSelected and varItem are for listboxes, not comboboxes.

You can test for nothing selected like so:

If Isnull(Me![PositiveGPE_Findings]) then Exit Sub

And use the .Value for checking whether to enable the control:

Me![Lymphnode_GP].Enabled = (Me![PositiveGPE_Findings].Value="Lymph Node")

A last thing to note is that .Value is the default property of textboxes and comboboxes, so if you simply write Me![PositiveGPE_Findings] it will be equivalent to Me![PositiveGPE_Findings].Value

[Yousaf Shah]

I tried this code as
Private Sub PositiveGPE_Findings_AfterUpdate()
If IsNull(Me![PositiveGPE_Findings]) Then Exit Sub
Me![Lymphnode_Gp].Enabled = (Me![PositiveGPE_Findings].Value = "Lymph Node")
End Sub
but it gives Run-time error '13' Type mismatch
...............
what to do....?