M:M Subform Combo Box

[ledgerr.rob]

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

 

[bob fitz]

You use a query called "qrySubScopeJunction" for the record source of your sub form.
Open that query in design mode and change the table setting (second row of the grid) from tblScope to tblJoinSubScope.

 

[ledgerr.rob]

Bob Fitz - Thank you very much. I appreciate you taking the time and looking at my problem.

I made the modification that you suggested and it appears all is working well.

Cheers!
rob