I am just leaning access so detailed steps to the code would be helpful.
Basically I have a text field "txt1" that populates my main table with numbers that either enter or take off two subforms "subform1" &"subform2" depending on the response that i need to give. I have queried the subforms to look up the info that i need based on a "combobox1"
Is there a code for when i add a new line to either subform1 or subform2 to have my text field auto populate with the number i entered in. There will never be a case when on the same record i would enter a number into subform1 and subform2. there are two fields in my subforms the first one is the new numbers I want to populate the text box and the second is the parent field that sets the criteria this field is hidden.
Any help or advice would be appreciated! Thank You!
Our community of experts have been thoroughly vetted for their expertise and industry experience.