Refresh issues in Microsoft Access are always a pain, especially in Access forms with various subforms. Trying using this code to refresh all open forms.
PASTE THIS VBA CODE into your database:
Public Sub RefreshAllForms()
Dim objFrm As Object
Dim strFrm As String Dim ctl As Control For Each objFrm In CurrentProject.AllForms
If objFrm.IsLoaded Then strFrm = objFrm.Name For Each ctl In Forms(strFrm).Controls If (ctl.ControlType = acComboBox) Or (ctl.ControlType = acListBox) Then ctl.Requery End If Next ctl Forms(strFrm).Refresh End If Next objFrm End Sub |
VBA >