Updating a field on another form using requery command.

[gold007eye]

I have a financial database and what I am trying to do is to have the main menu update the "current balance" field when a new transaction is saved in the "check register entry" form. here is what I am using, but it doesn't update the main menu. What am I doing wrong?

Private Sub Save_Click()
On Error GoTo Err_Save_Click


    DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70


Me![Add].Enabled = True
Me![Add].SetFocus
Me![Save].Enabled = False
Me![Print].Enabled = True

Me![Cleared].Enabled = False
Me![Check Number].Enabled = False
Me![Date].Enabled = False
Me![Transaction Description].Enabled = False
Me![Payment/Debit (-)].Enabled = False
Me![Code].Enabled = False
Me![Fees (-)].Enabled = False
Me![Deposit/Credit (+)].Enabled = False

DoCmd.OpenQuery "Checking Account Report Query", acViewNormal, acReadOnly
[Forms]![Main Menu]![Current Balance].Requery
DoCmd.Close acQuery, "Checking Account Report Query", acSaveNo

Exit_Save_Click:
    Exit Sub

Err_Save_Click:
    MsgBox Err.Description
    Resume Exit_Save_Click
    
End Sub