Combo box retains old row source

[Gkirkup]

I have a form on which the user enters a part number into a control. Then a combo box, with a query as the row source, displays all of the sub-variations of that part number. That works fine.
My problem is that when you enter a new part number in the control, the combo box is not updating. It still shows the records relating to the original entry.
I have tried a requery on the form, a requery on the combo box, and setting the combo box to null. Nothing works, it still shows the drop down list relating to the original entry.
Any ideas on this? How do I get the combo box to 'start over'?

Robert

 

[Poppa Smurf]

On the Got Focus of the combo box enter Docmd.requery "NAME" where name is the name of your combo box. Also make sure your combo box displays the correct list based on your selection in the part number.

 

[Gkirkup]

That worked perfectly. Thanks so much!

Robert