ledgerr.rob
Registered User.
- Local time
- Yesterday, 19:00
- Joined
- Jun 3, 2012
- Messages
- 68
I'm so close, I think! haha
I'm running Access 2016 on a Windows 7 machine.
I'm working on a project that incorporates subcontractors and their respective scopes of work.
I have built my join table, developed the 'subcontractor' main form,and insert the 'scope' subform onto the main form.
My goal is to add scopes for the subcontractors through the subform, via a combo box. Scopes include a 'title' and a 'description.' I want to select the scope section, and then auto populate the scope description.
So far i have been able to do everything with the exception of: 1) make the combo box selectable and 2) auto populate the 'description' box. I'm not worried about #2, i can do that. But I'm confusing myself with the combo box.
I've included a my sample database for anyone interested in where I am at.
Thank you for any tips or guidance.
rob
View attachment Subcontractor DB.zip
I'm running Access 2016 on a Windows 7 machine.
I'm working on a project that incorporates subcontractors and their respective scopes of work.
I have built my join table, developed the 'subcontractor' main form,and insert the 'scope' subform onto the main form.
My goal is to add scopes for the subcontractors through the subform, via a combo box. Scopes include a 'title' and a 'description.' I want to select the scope section, and then auto populate the scope description.
So far i have been able to do everything with the exception of: 1) make the combo box selectable and 2) auto populate the 'description' box. I'm not worried about #2, i can do that. But I'm confusing myself with the combo box.
I've included a my sample database for anyone interested in where I am at.
Thank you for any tips or guidance.
rob
View attachment Subcontractor DB.zip