Requery and Update

  • Thread starter Thread starter Milindra
  • Start date Start date
M

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
 
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)
 
Back
Top