KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
I've struggling with this problem on my own, then with some help, then search about it; but I haven't had any luck. So I decided to ask. I have two forms in Access 2007 lets call them MainForm and EntryForm . MainForm has a subform and a button. The button opens the EntryForm in Add Mode. What I want to do is when the EntryForm saves the new record it would update (requery) the subform in MainForm . I've try this setup code Private Sub cmdSaveAndClose_Click() DoCmd.Save 'requery list Forms![MainForm]![subformName].Requery '' I've also tried these 'Forms![MainForm]![subformName].Form.Requery 'Forms.("MainForm").[subformName].Requery 'Forms.("MainForm").[subformName].Form.Requery DoCmd.Close End Sub None of these attempts seem to work. Is there a way to make this requery? Thanks for the help in advance.
Tags (comma-separated)
Save Edits
Cancel