I have a global function that refreshes another form every time it is closed. There are two forms that open from the same form - however one doesn't refresh the primary form.
The primary form has a listbox that when it's count list <= 0 a button appears
else
the button dissapears and the listbox lists what it has
however this is not working. The records have been updated however the listbox is not updating and the button isn't dissapearing
I have
Code:
If CurrentProject.AllForms("frmSchools").IsLoaded Then
Forms!frmSchools.Form.Refresh
Forms!frmSchools!listCluster.Requery
If Forms!frmSchools!listCluster.ListCount <= 0 Then
Forms!frmSchools!txtClusterFind.Visible = True
Else
Forms!frmSchools!txtClusterFind.Visible = False
End If
end if
Any idea why sometimes it works and other times it doesn't?