Listbox populated on reports

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi
Access 2000

I have made a database to help collect data in my teaching. I have a
many-to-many relationship set up in a table to link a TASK with a teaching
STRATEGY. Many tasks can have many strategies. All works well on forms.
However ...

When I created a listbox on a report I thought I would simply be able to
populate its rowsource through an SQL statement on the 'on format' event
based on the TASK ID number. However, this is not an option.

How can I do this.

Many thanks

Leonard
 
Hi,
i think best way to show this will be a main report + subreport with
strategies. OR you can make only one report, recordsouce should list all
tasks and strategies, group it by task, and in details put strategies

HTH
 
Back
Top