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