I need help cleaning this up. I was practicing trying it myself I know I am close but need help.
Select Case Comboyesorno
Case "Yes"
Select Case Me.txtBenchmarks
Case "Revenue recorded incl. claims", "Free lunch for all students Yes/No", "Physical count conducted", "Prvide updted number of students daily rolled up monthly"
Me.txtMetGoal = "Met Goal"
End Select
Case Comboyesorno
Case "No"
Select Case Me.txtBenchmarks
Case "Revenue recorded incl. claims", "Free lunch for all students Yes/No", "Physical count conducted", "Prvide updted number of students daily rolled up monthly"
Me.txtMetGoal = "Did not meet Goal"
End Select
Case Comboyesorno
Case "Yes"
Select Case Me.txtBenchmarks
Case "No findings", "No commodities retained longer than 6 months", "No violations identified", "No major swings", "No disposals without proper recording"
Me.txtMetGoal = "Did not meet Goal"
End Select
Case Comboyesorno
Case "No"
Select Case Me.txtBenchmarks
Case "No findings", "No commodities retained longer than 6 months", "No violations identified", "No major swings", "No disposals without proper recording"
Me.txtMetGoal = "Met Goal"
End Select
End Select