I am using a combo box (cboBox1) to filter combo box 2 & 3 (cboBox2, cboBox3). I have the form set to continuous , in 'Afterupdate' in cboBox1 I have DoCmd.Requery "cboBox2"
DoCmd.Requery "cboBox3"
This seems to work for the first record, when I enter to the next record the data from cboBox2 & 3 which I selected disapears.
Also the filter stops working.
I'm stumped, can anyone help.

Russ

I don't understand what you mean when you say ". . . when I enter to the next record the data from . . ."

I assume you mean cbobox1. You got to requery on event OnExit too, because you might have changed the field and then changed it again.

I'll try to clarify. The results table records, [League] , [team1], [goals], [team2], [goals].

The form I have set up is set to Continuous, so I can enter (and view) multiple results.

I can select a league and this filters the teams ( so I don't have to select from 60 teams). This works ok for the first record(result). When I go to the next record and select a different league the previous results disapear ( though not in the underlying table). I don't know how to stop the 'League' refiltering all the records I have entered.

Thanks for your help.

Russell