Help with Requery

[marklane2001]

Please help.

I currently have a form (frm1) with a listbox on it (lst1)
lst1 has a filter on it
The filter is run from a query (qry1) which displays all current records from a table (tbl1)


When I select an item on lst1 it opens another form (frm2) and dependant on what is slected on lst1 is dependant what is displayed on frm2.

There is a button frm2 called btnUpdate - After it is pressed records are updated to tbl1 and frm2 is closed. As part of the btnUpdate_Click() I re run qyy1. Now frm1 has the focus but even though I have rerun qry1, lst1 has not refreshed. How can I refresh this field

 

[MarkK]

btnUpdate on Form2 can requery Form1.lst1

private sub btnUpdate_Click()
  '...
  '...
  if currentproject.allforms("Form1").isloaded then forms("Form1").lst1.requery
end sub