troubleshooting Question

Subform to populate text field on main form.

Avatar of thefourthwm
thefourthwm asked on
Microsoft Access
4 Comments1 Solution359 ViewsLast Modified:
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.

Log in to continue reading
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform for $9.99/mo
View membership options
Unlock 1 Answer and 4 Comments.
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
The Value of Experts Exchange in My Daily IT Life

Experts Exchange (EE) has become my company's go-to resource to get answers. I've used EE to make decisions, solve problems and even save customers. OutagesIO has been a challenging project and... Keep reading >>


Owner of Outages.IO
Phoenix, Arizona, United States
Member Since 2016
Join a full scale community that combines the best parts of other tools into one platform.
Unlock 1 Answer and 4 Comments.
View membership options
“All of life is about relationships, and EE has made a virtual community a real community. It lifts everyone's boat.”
William Peck

Member since 2004