how to calculate total of selected combo box items

richardmagaisa
If Me.cbobraketype.SelectedItem = ("Rim Brakes") Then
        braketype = ("Rim Brakes")
        price = "£120"
        braketype = ("Rim Brakes")


    ElseIf Me.cbobraketype.SelectedItem = ("Disk Brakes") Then
        braketype = ("Disk Brakes")
        price = "£150"
        braketype = ("Disk Brakes")



    End If

    'choose type of frame
    If Me.cboframetype.SelectedItem = ("Aluminium") Then
        frametype = ("Aluminium")

    End If

    'choose type of brakes
    If Me.cbobraketype.SelectedItem = ("Rim Brakes") Then
        braketype = ("Rim Brakes")
        price = "£390"
        braketype = ("Rim Brakes")

    ElseIf Me.cbobraketype.SelectedItem = ("Disk Brakes") Then
        braketype = ("Disk Brakes")
        price = "£430"
        braketype = ("Disk Brakes")

    End If
64 Views
About the Author
 If Me.cbobraketype.SelectedItem = ("Rim Brakes") Then
            braketype = ("Rim Brakes")
            price = "£120"
            braketype = ("Rim Brakes")


        ElseIf Me.cbobraketype.SelectedItem = ("Disk Brakes") Then
            braketype = ("Disk Brakes")
            price = "£150"
            braketype = ("Disk Brakes")



        End If

        'choose type of frame
        If Me.cboframetype.SelectedItem = ("Aluminium") Then
            frametype = ("Aluminium")

        End If

        'choose type of brakes
        If Me.cbobraketype.SelectedItem = ("Rim Brakes") Then
            braketype = ("Rim Brakes")
            price = "£390"
            braketype = ("Rim Brakes")

        ElseIf Me.cbobraketype.SelectedItem = ("Disk Brakes") Then
            braketype = ("Disk Brakes")
            price = "£430"
            braketype = ("Disk Brakes")

        End If
Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.21 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.