Options to show only if main box checked "yes"

[mkfloque]

Hello,
I'd like secondary options to show only if main box is checked yes.
For example, a list of dessert options (pie, cake, etc) show only if "dessert wanted?" box is checked "yes".


Thank you!

[Missinglinq]

You'll need to use your own actual Control names, of course:

Private Sub DessertWanted_AfterUpdate()
 If Me.DessertWanted = -1 Then
  Pie.Visible = True
  Cake.Visible = True
 Else
   Pie.Visible = False
  Cake.Visible = False
 End If
End Sub

Private Sub Form_Current()
 If Me.DessertWanted = -1 Then
  Pie.Visible = True
  Cake.Visible = True
 Else
   Pie.Visible = False
  Cake.Visible = False
 End If
End Sub

And this has to be a Single View Form, as you cannot make Controls Visible/Invisible on a Record-by-Record basis on Datasheet and Continuous View Forms.

Linq ;0)>

[mkfloque]

You'll need to use your own actual Control names, of course:

Private Sub DessertWanted_AfterUpdate()
 If Me.DessertWanted = -1 Then
  Pie.Visible = True
  Cake.Visible = True
 Else
   Pie.Visible = False
  Cake.Visible = False
 End If
End Sub

Private Sub Form_Current()
 If Me.DessertWanted = -1 Then
  Pie.Visible = True
  Cake.Visible = True
 Else
   Pie.Visible = False
  Cake.Visible = False
 End If
End Sub

And this has to be a Single View Form, as you cannot make Controls Visible/Invisible on a Record-by-Record basis on Datasheet and Continuous View Forms.

Linq ;0)>

Thank you! I'm very new to code and will try this. I'm going to make a combo box for the dessert choices Thanks again...