Listbox populated on reports

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
 
A

Alex Dybenko

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Adding icons to listbox 6
Listbox limit 2
Requery form from another form 2
Create a Table with Multiple Values Listbox 0
Exclusive Access Conflict 5
Filter Multiselect Listbox 4
Sorting listbox contents 3
Add multiple values on table based on listbox 0

Top