refresh dropdown list in subform

[MadAccess]

I have a subform with a combobox where the user can add new items to the table the combobox pulls from (tblProducts). That way if they look for a product that doesn't exist they can immediately add it.
However, if they move to the next record in the subform and try to select the product they just added, it isn't there.
I added a docmd.save and that didn't work. Any ideas?

Thanks

 

[MichaelJ]

Hi Mad,

Try doing a requery of the form in the after update event of the combo box where you are adding the new data.

Actually, you can put Me.Requery after the save command line in your code.

Mike

 

[MadAccess]

Thanks, MichaelJ. After the table behind the combobox was updated, the requery action did it. Thanks