M:M Subform Combo Box (1 Viewer)

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
 

bob fitz

AWF VIP
Local time
Today, 02:00
Joined
May 23, 2011
Messages
4,717
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

Registered User.
Local time
Yesterday, 19:00
Joined
Jun 3, 2012
Messages
68
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
 

Users who are viewing this thread

Top Bottom