Requery not clearing box (1 Viewer)

[samjh]

Hi,

i have a form with cascading combo boxes, all of which are set to requery the combo boxes below, however i have one which is Service SubType, and it should requery Provider and Subjective, however it only clears the Provider and the previously selected subjective is still there, when you click on the downarrow it does give you the new list of subjectives.

my code looks like this:
Private Sub cmbServiceSubType_AfterUpdate()
Me.cmbProvider.Requery
Me.cmbSubjective.Requery
End Sub

Does any know how to get it to clear the boxes I have asked it to requery.

Thanks

 

[CJ_London]

Is the cmbSubjective a bound control?

If so and the value is in both the 'old' and 'new' list this will appear not to clear

If you want to completely reset then you will need to assign a value to the bound control e.g

cmbSubjective.Requery
cmbSubjective = 0 ' or "" if bound fieldtype is text