K Kenln Registered User. Local time Today, 17:59 Joined Oct 11, 2006 Messages 551 Mar 2, 2009 #1 Is there a way to force the saving of a record in a different form? I would like to update/save the record of a pop-up form from another open form.
Is there a way to force the saving of a record in a different form? I would like to update/save the record of a pop-up form from another open form.
wazz Super Moderator Local time Tomorrow, 06:59 Joined Jun 29, 2004 Messages 1,702 Mar 2, 2009 #2 set focus to the other form first: Code: Forms!frmPopup.SetFocus DoCmd.RunCommand acCmdSaveRecord
K Kenln Registered User. Local time Today, 17:59 Joined Oct 11, 2006 Messages 551 Mar 2, 2009 #3 Can I call this from the Main (non-popup) or do I need to execute it from a seperate VBA module?
wazz Super Moderator Local time Tomorrow, 06:59 Joined Jun 29, 2004 Messages 1,702 Mar 3, 2009 #4 you can do it from the main form (or anywhere else). you'll probably want to reset the focus back to whatever form you're on.
you can do it from the main form (or anywhere else). you'll probably want to reset the focus back to whatever form you're on.
