Listbox in a continuous subform

[JohanV]

Hey all!

I realise this must have been posted before, but I didn't find an answer by searching this site or the net. I'm hoping someone can tell me how to fix this, or can show me a different approach.

The Access db I'm making is for basic job scheduling. Every day has several jobs and each job can have different employees assigned to it. Basic tables are:
tblJobs, tblJobEmp, tblEmployees

tblJobEmp is the one providing the link between tblJob and tblEmployees. It has several records per job, linking JobID with EmpID. (So if three emps are assigned to a job this table has three records for that JobID)

On my main form, I show a listing of jobs on a selected date. The jobs are listed in a subform. Now I'd like to have a listbox (or anything else) per record in the subform showing the assigned employees to that job.
No matter what I tried, I keep getting the emps from the first job for every job or nothing at all.

So if anyone can give me a way to solve this (I'm thinking a listbox might not be the way to go) I'd appreciate it!

Thanks in advance,
Johan

[Rabbit]

Hey all!

I realise this must have been posted before, but I didn't find an answer by searching this site or the net. I'm hoping someone can tell me how to fix this, or can show me a different approach.

The Access db I'm making is for basic job scheduling. Every day has several jobs and each job can have different employees assigned to it. Basic tables are:
tblJobs, tblJobEmp, tblEmployees

tblJobEmp is the one providing the link between tblJob and tblEmployees. It has several records per job, linking JobID with EmpID. (So if three emps are assigned to a job this table has three records for that JobID)

On my main form, I show a listing of jobs on a selected date. The jobs are listed in a subform. Now I'd like to have a listbox (or anything else) per record in the subform showing the assigned employees to that job.
No matter what I tried, I keep getting the emps from the first job for every job or nothing at all.

So if anyone can give me a way to solve this (I'm thinking a listbox might not be the way to go) I'd appreciate it!

Thanks in advance,
Johan

What's the row source of the list box?

[JohanV]

I tried different things... Like running a query that filters out all Emps where the JobID matches... but it only does it once, which then is shown in every listbox for every record.

[MMcCarthy]

Hi Johan

As I understand it you have a datasheet or continuous form as your subform of jobs in which you want to show a list of employees assigned per job.

The listbox or combobox row source will change depending on what record is in focus which is why it's changing for all records. You will need to create a further subform to show this list.

Mary

[JohanV]

Thanks,

I didn't manage to get it working (had no time left) because I had to show the prototype to the client today.
All turned out well tho and I can start in the real work.

Cheers
Johan