update combo box on form close

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
 
R

RonaldoOneNil

Just before you close the frmManufacture form, put this code

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Update Combo Box 3
combo box locked 4
A couple questions about combo boxes 1
How to close a form based on item in combo box 2
copying data from tabel to table 3
update combo box 6
Access Sub form opens before the main form in MS Access 0
combo box 1

Top