List Box and combobox control help needed

[sdmikejr]

Hello,
I have a list box on a form with 3 combo boxes. Depending on the users selection of the list box, 2 of the 3 combo boxes are enabled for the user to make selections on.

If the user proceeds to a combo box that is enabled, makes a selection and then chooses to go back up to the list box, the combo box does not reset.

Can someone help me out. Essentially, I need to know how to reset the combo boxes should the user make a different selection in the list box.

Thank you in advance!!

[OBP]

Me.comboboxname.requery

Where comboboxname is the actual name of your combo box.

[sdmikejr]

Thank you, I'm a newbie so I need a bit more understanding. Where in this code would I put this:

Enum SalesPeriodEnum    ByQuarter = 1
    ByTerm = 2
    ByYear = 3
End Enum
Private Sub lstSalesPeriod_AfterUpdate()
    SetSalesPeriod Me.lstSalesPeriod
End Sub


Sub SetSalesPeriod(SalesPeriod As SalesPeriodEnum)
    Me.lstSalesPeriod = SalesPeriod
    Me.cbTerm.Enabled = (SalesPeriod = ByTerm)
    Me.cbQuarter.Enabled = (SalesPeriod = ByQuarter)
End Sub

[sdmikejr]

OMG - I figured it out!! Thank you for the direction!!!

Private Sub lstSalesPeriod_AfterUpdate()    SetSalesPeriod Me.lstSalesPeriod
    cbYear = Null
    cbQuarter = Null
    cbTerm = Null
    cbYear.Requery
    cbQuarter.Requery
    cbTerm.Requery
End Sub

[OBP]

Well done, sorry for the delay in getting back to you.