update combo box on form close

  • Thread starter Thread starter Simon
  • Start date Start date
S

Simon

I have a form that has a drop down list of Manufactures Names. next to
the drop down i have a button that opens up a new from that enables me
to add a new manufacture It also gives it an ManufactureID Number.
Once i close the form i want to to display it it on the main form, how
do i do this as its not included in the drop down list until i close
and reload the from

Main for name frmProduct
Field on Main form cboManufactureID

Add manuafacture Form frmManufactrue
txtManufacture
txtManufactureID
 
Just before you close the frmManufacture form, put this code

[Forms]![frmProduct]![cboManufactureID].Requery
 
Back
Top