Report value list

[Teri B]

Hi, I have created a sub-form Roles. In my course form the user selects the roles assigned to the course.
0ne-to-many. One course many roles.

Then I created a report based on the Course form and role Sub form.

I brought the sub=form into the report and it has the correct values, but it does not have the same look and feel as the other fields.

I created a list box in the report for roles, but it displays all the roles, not limiting the list by catalogID.
I was wondering if there was a way to get the list box to show only the records associated with the catalogID like on the sub-form, Parent-Child Relationship.

[NeoPa]

Hi Teri.

As far as I know, assuming you've rejected the more usual idea of using a SubForm/Report object for this, and it looks like you have, ListBox controls do not support the Parent/Child linking properties.

That said, if you'd like to use the ListBox object then it can be set with a ControlSource value that excludes records that don't match some other linked Control.

Do you have something available that you'd want to link it to in that way? It's also possible to update the ControlSource value when it (The Report) is opened or Loaded. I would suggest the other approach be tried first if you have that available though.

Your question doesn't share other details of what's available - probably because you weren't aware of the need before, so let's get that info & we can look at how we might proceed in more detail - always assuming you need more detail than already shown of course.

A good rule of thumb, for other times, is to include names of all relevant objects. That also makes it easier for us to pitch the answer in terms that make easiest sense to you.