Access combo-box

[philiprodley]

Returning to Access after years of break!

Have combo box on form populated with 3 records:

Height
Weight
Width

I wish to make height fields visible on the form if I select height, but others remain invisible.

When I select weight, then the height fields become invisible and the weight fields become visible.

Help here is greatly appreciated.

[MMcCarthy]

In the AfterUpdate event of the combobox put the following code (adapted to your control names)

Private Sub comboBoxName_AfterUpdate()
 
  SELECT CASE ComboBoxName.Value
    CASE "Height"
      Me.txtHeight.Visible = True
      Me.txtWeight.Visible = False
      Me.txtWidth.Visible = False
    CASE "Weight"
      Me.txtHeight.Visible = False
      Me.txtWeight.Visible = True
      Me.txtWidth.Visible = False
    CASE "Width"
      Me.txtHeight.Visible = False
      Me.txtWeight.Visible = False
      Me.txtWidth.Visible = True
  End SELECT
 
End Sub
 

Mary

[NeoPa]

This code should work too.
It's a bit more expandable (Easier to add extra levels of selection).

Private Sub cboBox_AfterUpdate()
    Me!txtHeight.Visible = (Me!cboBox = "Height")
    Me!txtWeight.Visible = (Me!cboBox = "Weight")
    Me!txtWidth.Visible = (Me!cboBox = "Width")
End Sub

[philiprodley]

Thank you, Mary and NeoPa--

That's just fine

[NeoPa]

Pleased to hear it's working for you :)

[MMcCarthy]

Pleased to hear it's working for you :)

You're welcome.