troubleshooting Question

How do I populate my subform with values from multiple columns - only populating value from one column

Avatar of donvike1
donvike1Flag for United States of America asked on
Microsoft Access
4 Comments2 Solutions324 ViewsLast Modified:
I have a subform (frm_ProblemList_subform) within a form (frm_UltraPage)
The subform is populating data from tbl_OfficeVisit and tbl_ICD9
The problem is that I'm only populating data from one column - I would like to populate data from 3 columns instead of one
The 3 columns are ICD9,  ICD92,  ICD93,  from tbl_OfficeVisit and Short_Description from tbl_ICD9
How do I get my subform to populate the other two columns value?

Here is my syntax  also see the attachment with the screenshot of the form and the table - the data is fictisous)

SELECT [tbl_OfficeVisits].[ICD9_Code], [tbl_ICD9].[Description], [tbl_OfficeVisits].[Patient_id] FROM tbl_ICD9 INNER JOIN tbl_OfficeVisits ON tbl_ICD9.ICD9_Code=tbl_OfficeVisits.ICD9_Code;

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 2 Answers and 4 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 4 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros