Reports Combobox-List box

[Teri Bridges]

I have a form that has a cbobox where the user selects the roles to assign to a course.

I then have a qry that runs and list the role to course results.
I have a form, based on course ID, where I would like to have a list box of the roles assigned. Currently, I can get each role individually but this makes for a very clunky report.
For Example, I have course 1. Course 1 has two roles assigned Roles A,B. I would like to have a list box Showing A,B. Any suggestions or help in resolving this issue is greatly appreciated. I am very new to coding.

I was reading some articles here and think I need to do something like a get function. I am really not sure what to do.

 

[dhookom]

Have you considered a subreport? You didn’t mention if you used a multi-select combo box. I don’t like multi-select since it creates issues.

Duane
Minnesota
Hook'D on Access
MS Access MVP 2001-2016