Refreshing a list

[Always_Learning]

Hi There,

In need of your help again.

I have a form with a list on it called Lst_Areas.
I can multiselect from the list and then click a button which opens another form for me to do some work on the selected list items. Once I am done and close the form which takes me back to the form with Lst_Areas on it, I need to reshow Lst_Areas to show the list without the items I worked on.

I have tried Lst_Areas.Refresh in loads of places, on the form with Lst_Areas on it and in the form I use to work on the items selected but nothing works.

The form with Lst_Areas on it is called Frm_SearchAreas and the and the form I use to edit the chosen listitems is called Frm_EditAreas

Any help you can give me would be appreciated.

Best Regards,

 

[robslob]

I have a form with a similar setup, what I did was click a button to close the form and then open it again which will start it afresh.

DoCmd.Close
DoCmd.OpenForm "Frm_SearchAreas"

 

[jdraw]

There is a good video on using 2 listboxes for such things here.
A form with 2 list boxes is what I'm suggesting as a starting point.

 

[MLUCKHAM]

I would suggest you make sure your list is based on a query referencing a Edit flag. When you open up a form to edit your selected items open the form as a dialogue. When you edit your items update the edit flag on the underlying table. After the open command place a listbox.requery. As you open the form as a dialogue code is not excuted until you close the form. Place a listbox.requery after the open command and the edited items would have disappeared.