Combo 'none' option

[fraser_lindsay]

Hello,

I have a combo which I have set to activate successive combos when a selection is made in it.

Unfortunately if you delet what is in it i.e. to make it empty it does not deactivate the other combos. I presume this is a peculiarity with combos as once you have clicked in it it is active?

is there anyway of getting Acess to recognise you don't want to use a particular combo by removing the data manually or by selecting a 'none' option in the combo?

Does this make any sense?

 

[MStef]

In Sub Firstcombo_AterUpdate put this code;
Me.NextCobo.Requery