Aditional values in a cont. subform

[JohanV]

Hey all!

I'm having some trouble showing all data I want on my form. I'll explain what the database does first:
It's designed to allow us to plan tasks for our teams that go on the road. A team is variable, meaning one day it can be person A and B, second day it's A and C.

As far as tables go. I got the main task table, an 'in between' table that has multiple records per task, where TaskID is linked with EmpID (thus making as many records as there are assigned employees). Then I can use that EmpID to find the employee name in the employee table.

Rigth now, the form consists of a calendar control, once you select a date, a continious subform shows all tasks scheduled on that date. However, I'd like a listbox or textfield in that subform to be populated with all employees assigned to a specific task.

All efforts so far haven't gotten me far, so any help is appreciated!

Thanks,
Johan

 

[JohanV]

Hello...

When I run my main form thing don't seem to work like I stated in the above post. When I run the query when the sub-subform is open it doesn't work either, however when I put focus on one of the records it does work...

Any ideas on how to get this form working?

Thanks.
Johan