listbox refresh upon return from another form

[ngreenleaf]

I have a form (call it form1) that opens another form (form2). Form1 has a listbox on it and the data in that list box is changed when leaving form2 and returning to form1. In particular, form2 allows the user to delete rows that would be displayed in that list box when the Done command button is clicked, and after the delete the form is closed and the original form made visible again.

What is happening is that when I return to form1 the deleted row says "#delete". It eventually goes away when I do an operation that requeries the listbox, but I can't find a way to requery the listbox when I return form1. I tried events such as on getfocus, on load, on current. I tried me.refresh for the form as well as requerying the listbox.

Ideas are much appreciated...

 

[BillPower]

In your form's Activate event, try:

Me!YourListBoxName.Requery

 

[ngreenleaf]

Many thanks... works like a charm