Afternoon all

Slight problem, i've got several check buttons on a form so that the user can select more than one option. I thought that a case statement would be the best way to check which of the values are set to "True". If the value is True then a word would be passed to a string. Problem being that my string just isn't building up depending on what options have been selected.

Here take a look at this:-
Code:
Select Case Appointment
    Case chkDentist.Value = True
        Appointment = "Dentist"
    Case chkDoctor.Value = True
        Appointment = Appointment & "Doctor "
    Case chkHospital.Value = True
        Appointment = Appointment & ", " & "Hospital "
    Case chkOptician.Value = True
        Appointment = Appointment & ", " & "Optician "
    Case chkOther.Value = True
        Appointment = Appointment & ", " & txtOther.Text
End Select
I can't see why this isn't working, the variable Appointment is set as a string and should be creating a string of options

Your help on this would be great

Thanks

Nick