Updating Continuous Subform with Command Button Sub

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to update a continuous subform (sfrmProdList) showing Product
Category and Product textboxes using an Add Product form (frmProdAdd) with
combo boxes (cmb ProdCat and cmbProd) and a "Done" command button. The
subform (sfrmProdList) parent form (frmCust) contains customer information,
where sfrmProdList changes from customer record to customer record.

When I make a new product selection using frmProdAdd and click the "Done"
button, all relevant tables, queries, etc. update properly. I have not,
however, been able to find the code that will update (sfrmProdList) at that
time. The list does not update, but if I move to the next customer and then
move back to the updated customer, the new product shows up on sfrmProdList.

How can I get sfrmProdList to update when I click the "Done" command button?
Thanks for your help.

Bill Schaupp
 
Force the subform to requery the database with:
Forms!frmCust!sfrmProdList.Requery
placed somewhere in the code of Done button's Click event.

TomU
 
Cool!! It worked!!

TomU said:
Force the subform to requery the database with:
Forms!frmCust!sfrmProdList.Requery
placed somewhere in the code of Done button's Click event.

TomU
Click to expand...
 
Back
Top