I have a Main form with a subform named Payments.
I have a button on the main form named NewPaymentEntry that opens a small
popup form to enter a new payment.
There is a "Save" , "Cancel", and "Close" button.
When I click "Close" I want it to automatically refresh the Payments subform
so I can see the new payment. How can I make this happen. (the interesting
thing is - it used to do this automatically before... but not any more....)
Here's the current "Close" code onclick event:
--------------------------------------------------------
Private Sub cmdClose_Click( )
On Error GoTo Err_cmdClose_Cl ick
DoCmd.Close
Exit_cmdClose_C lick:
Exit Sub
Err_cmdClose_Cl ick:
MsgBox Err.Description
Resume Exit_cmdClose_C lick
End Sub
-----------------------------------------------------------
Any help for this VBA newbie would be greatly appreciated. :)
<3 Presto
I have a button on the main form named NewPaymentEntry that opens a small
popup form to enter a new payment.
There is a "Save" , "Cancel", and "Close" button.
When I click "Close" I want it to automatically refresh the Payments subform
so I can see the new payment. How can I make this happen. (the interesting
thing is - it used to do this automatically before... but not any more....)
Here's the current "Close" code onclick event:
--------------------------------------------------------
Private Sub cmdClose_Click( )
On Error GoTo Err_cmdClose_Cl ick
DoCmd.Close
Exit_cmdClose_C lick:
Exit Sub
Err_cmdClose_Cl ick:
MsgBox Err.Description
Resume Exit_cmdClose_C lick
End Sub
-----------------------------------------------------------
Any help for this VBA newbie would be greatly appreciated. :)
<3 Presto