Removing choosen Item from ComboBox

[Dina01]

Hello,

I ahve a from that has a few combo bo and what I would like it to do is that if I choose a name in the first box, well that name should not appear in the second combo box, and if I choose one from the 1 and 2, well does name should not appear in the 3rd box.

This is the code That I have and used to work before...but it's not working anymore and I don't know why.

can someone please help
************************

Private Sub Agt1_AfterUpdate()
On Error Resume Next

Me.Agt2.Requery
Me.Agt3.Requery
Me.Agt4.Requery
Me.Agt5.Requery
Me.Agt6.Requery
Me.Agt7.Requery
Me.Ambu.Requery
Me.Patrouille.Requery

End Sub

Private Sub Agt2_AfterUpdate()
On Error Resume Next

Me.Agt3.Requery
Me.Agt4.Requery
Me.Agt5.Requery
Me.Agt6.Requery
Me.Agt7.Requery
Me.Ambu.Requery
Me.Patrouille.Requery

End Sub

Private Sub Agt3_AfterUpdate()
On Error Resume Next

Me.Agt4.Requery
Me.Agt5.Requery
Me.Agt6.Requery
Me.Agt7.Requery
Me.Ambu.Requery
Me.Patrouille.Requery

End Sub

and so on

 

[Dina01]

Can anyone help me with this...

 

[scriverb]

If it was working at some time in the past and now is not working we need to look at what has changed in your database. Anything. Just us some ideas as to what to consider.

Bob Scriver