Requery and Update

[Milindra]

I created a dropdown on product form for a user to choose
a cotegory from the list and user can I also add a new
category if they want by Double click on the dropdown. It
will open category form

My question is when I add a new category and close
category form. It doesn't automatically update on my
category dropdown. Is there any way I can do automatic
update.

Thank in advance,
Milindra

 

[Van T. Dinh]

You need to Requery the ComboBox on the frmProduct using
the Form_Unload or Form_AfterUpdate or Form_AfterInsert
Event of the frmCategory.

HTH
Van T. Dinh
MVP (Access)