Listbox update

[Pgill]

Hi Guys,



I have created a list box on my form that gives me a choice of equipment types. The list works great..... But if I need to add more equipment to the list (separate table) I have a button which when clicked opens a form to the equipment table where I can add the new equipment..... this works well.....
But when I go back to my original form to use the listbox and choose the new equipment, it is still not there..... I have to close that form and then reopen it to refresh the list on the form......
What I would like to know..... Is there a way to add equipment to my table through the add equipment button, and when I close the add equipment form... it updates the listbox on my form without having to close my form?

Any help is appreciated,

Peter

[Access_Blaster]

In the On close event of the 2nd form try Me.Requery

[rpeare]

In the on close property of the form where you enter new equipment put in this

forms!<formname1>!<listboxname>.requery

where formname 1 is your primary form listboxname is the listbox where your equipment appears.

[Pgill]

Hi guys,

Thanks for the help.... Rpeare, this is a carry on from my last topic..... In my test base, the detector type box I removed and added a Combo box that links to a table called Detector Type..... I also placed a button that runs a macro to open the form that links to Detector Type table..... This is where I add detector models..... When I have added the detector and closed the box, I click on my Combo dropdown box, and the new selection is not there.... But if I close the main form and reopen the form and the dropdown it is there......

I have tried the me.requery that Access_Blaster told me and I have tried your, although not sure if the syntax is correct...... But anyway, still not working..... I have linked the code to the Click-on and the On-Focus, but also does not work..... Umm I am really battling..... If I get this one right..... my base will be complete as all my other repairs and mods have been done.....

Table = Detector Type
Form = Main (with dropdown and button) Dropdown = Combo181
Add Detector Form = Detector Type (links to the Detector type table)

If you can type out your command using what I have given you, I am sure it will help....

Thanks again to both of you.....

Peter

[rpeare]

can you post a copy of your database please