I have a form (F_Finance_Budget) that users input data then hit a command button (which runs a module) to have that data placed in a holding table. I have found code that opens a message box. In this module, I would like the form to close if the user selects "Yes". The code I have below does not work. When I hover over the yellow highlighted "F_Finance_Budget" in debug, it says "F_Finance_Budget=Empty". Thank you all for your help in advance!
Dim ReturnVal As Integer
ReturnVal = MsgBox("Are you ready to update?", 35, "Update")
If ReturnVal = vbYes Then
DoCmd.Close acForm, F_Finance_Budget, acSaveNo
End If