I'm having a problem with Requery.  I have 7 combo boxes that are cascading.
One gets it's data from the previous one.  The first three requery and blank
out the combo boxes if the item that was selected isn't in the new list.
Although the last four do requery and get a new list, they keep the previous
selected text even if it isn't in the new list.  I set the Limit To List
option but that didn't have an effect on the last four combo boxes. I posted
the different ways I've tried requerying below.  The only one that seems to
remove the data is DoCmd.Requery but only does it for Client, and Contract.

Any  help is much appreciated!

Private Sub cbManf_AfterUpdate()
Me("cbEquipType").Requery
End Sub

Private Sub cbVessel_AfterUpdate()
DoCmd.Requery "cbClient"
DoCmd.Requery "cbContract"
DoCmd.Requery "cbManf"
DoCmd.Requery "cbEquipType"
End Sub

Thanks.
--
Infotech