Requery doesn't, example attached

[Steven811]

Hi

I have attached a stripped down version to demonstrate my problem, you will also see an example of the cascading combo boxes that I have created with the assistance of mile-o-phile's examples.

When I have been through the combo boxes once and made my selection everything is fine. When I go back to the top and start again, the next but one combo doesn't requery as I have planned. (The giveaway is the record counter)

I have tried to make it happen with OnUpdate, OnChange and OnClick without success.

The odd thing is that the same code clears the display as it should.

Any assistance would be appreciated.

Steven811

 

[ecniv]

Seems to work fine - no records for the other three, so the drop lists aren't filled.

What exactly is not working?

 

[Steven811]

Requery code

Hi Ecniv

The code clears the fields as it should however, the 3rd combo retains the record set from the previous selection. If you look at the record counter of the 3rd combo, this remains unchanged.

This problem seems to affect the next but one combo. Which ever one is selected the combo immediately below it clears and shows the correct records, the next one retains the previous selection and the last combo clears correctly.

The first time the records are selected when the form is opened is fine, it's only after new records are selected that the problem presents it self.

Any insight into why this is happening would be appreciated.

Steven811