Form/Subform Connection

%3CLINGO-SUB%20id%3D%22lingo-sub-1789330%22%20slang%3D%22en-US%22%3EForm%2FSubform%20Connection%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1789330%22%20slang%3D%22en-US%22%3E%3CP%3EWhen%20clicking%20through%20records%20via%20a%20%22Next%20Record%22%20or%20%22Previous%20Record%22%20button%20on%20a%20form%2C%20how%20can%20I%20get%20the%20subform%20record%20to%20change%20along%20with%20it%3F%20In%20the%20picture%20below%20my%20form%20pulls%2Finputs%20information%20from%20my%20Submission%20Summary%20table%20and%20the%20subform%20(the%20orange-y%20area)%20pulls%2Finputs%20information%20from%20the%20Submission%20Details%20table.%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Kwoolridge_0-1602870862416.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F227204i1F8CB0832B35FAE2%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Kwoolridge_0-1602870862416.png%22%20alt%3D%22Kwoolridge_0-1602870862416.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3ESometimes%2C%20I'll%20have%20to%20alter%20an%20item%20that%20has%20already%20been%20entered%20into%20the%20form%2C%20but%20I%20want%20to%20keep%20a%20record%20of%20the%20original%20submission%20as%20well%20as%20the%20new%20submission%20like%20below.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Kwoolridge_1-1602871018542.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F227205i7818DDF482E15072%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Kwoolridge_1-1602871018542.png%22%20alt%3D%22Kwoolridge_1-1602871018542.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EIf%20I%20click%20the%20%22Next%20Record%22%20button%20the%20form%20will%20display%20both%20entries%20of%20this%20item%20%23%2C%20but%20the%20subform%20doesn't%20change.%26nbsp%3B%3CBR%20%2F%3ECurrently%20the%20form%20and%20subform%20are%20connected%20via%20the%20item%20%23%3B%20I%20think%20connecting%20via%20the%20UPC%20will%20cause%20the%20same%20problem%2C%20and%20the%20only%20other%20thing%20I%20can%20think%20of%20connecting%20through%20is%20the%20Submission%20%23%2C%20but%20I%20more%20often%20have%20multiple%20items%20on%20a%20submission%20than%20changes%20to%20items%20that%20have%20bene%20previously%20entered.%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20thoughts%20on%20how%20to%20get%20my%20subform%20to%20go%20through%20the%20records%20along%20with%20the%20form%3F%20Prefereable%20without%20having%20to%20get%20into%20VBA....because%20I'm%20not%20that%20advanced.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EKendra%20Woolridge%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1789330%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAccess%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

When clicking through records via a "Next Record" or "Previous Record" button on a form, how can I get the subform record to change along with it? In the picture below my form pulls/inputs information from my Submission Summary table and the subform (the orange-y area) pulls/inputs information from the Submission Details table. 

Kwoolridge_0-1602870862416.png

Sometimes, I'll have to alter an item that has already been entered into the form, but I want to keep a record of the original submission as well as the new submission like below.

Kwoolridge_1-1602871018542.png

If I click the "Next Record" button the form will display both entries of this item #, but the subform doesn't change. 
Currently the form and subform are connected via the item #; I think connecting via the UPC will cause the same problem, and the only other thing I can think of connecting through is the Submission #, but I more often have multiple items on a submission than changes to items that have bene previously entered. 

Any thoughts on how to get my subform to go through the records along with the form? Prefereable without having to get into VBA....because I'm not that advanced.

 

Thanks,

 

Kendra Woolridge

 

0 Replies