I have a form which has two sub-forms on it. The user is able to user drop down boxes to filter both of these sub-forms at the same time.

The problem I have is that when the user tries to clear the filter on both sub-forms, only the first sub-form clears. Here is my code:

Me.cboFinYear = Null
Me.cboMonth = Null
Me.cboBusinessArea = Null

Me!frmCostingAllocations.Form.FilterOn = False
strAllocationFilter = ""
Me!frmCostingAllocations.Form.Refresh

Me!frmCostingDetail.Form.FilterOn = False
strFilter = ""
Me!frmCostingDetail.Form.Refresh

So in the code above, the ‘frmCostingAllocations’ form will clear, but the ‘frmCostingDetail’ form won’t. If I reverse the order in the code above, the first one listed in the code clears but the second one doesn’t.

Does anyone know why this is and how to fix it?

Cheers,

Hi,

Did you try using a requery instead of a refresh?