Drop down box requery problem

[Nicholas]

I am now creating a purchase order form for my company.
In the form, I create a drop down box for user to select the supplier name for the order. Also, I've create a button to open another form to input the new supplier data if it doesn't exist.

The problem is that, after I've click on the button, type a new supplier info in the supplier form, close it. Then I click on the drop down box, I cannot see the new supplier name which I've created. I have to close the purchase order form, and reopen it, then I'll see the updated name shown in the drop down box.



Is any one know what's the problem? Is there any thing I have to do in order to force the drop down box to requery the values???

[StepUP]

When you close the form that adds a supplier, requery the drop down box:

Forms("MyForm")("MyControl").Requery