combo box of main form define combo box list of subform

[kigor]

Hello,
I try to connect combo box of main form define combo box list of subform.
Le me explain.
I have four table.
Table 1: job list with field: jobId, jobname, job description, job date
Table 2: job name: simple list of possible job used by Table 1
Table 3: work list: it have workID, jobid (connected with jobid of Table 1), workedname, kindofwork, hours
Table 4: list of work what worker can do: kindofworkid, jobnameID, kindofwork

Table 1 and 3 are main one, connecte by jobid

Where I input in form I pur jobname (from list of Table 2), descrption and date
Then I think to have subform with list of worker do this job and they kindofwork. So info from Table 3
Possible kindofwork is define by jobname.

so for example let say we have Jobname1 and Jobname2
In table 4 is define that Job 1 have kindofwork1, 2, 3, 4
And Job2: have kindofwork 5, 6

So if I define jobname2 in mainform I look to have in subform onyl kindofwork5 and 6.

So two combo box in this question is Jobname (table2) and kindofwork (table4)

If it is in one form Jobname combobox will have afterupdate event wiht Rowsource.

How to do this with subform?

 

[kigor]

I believe all my problem is bad reference.
Look this name:

Mainform name: Lavoro nuovo
subform name: Lavoratori
In subform is show form name: Lavoro nuovo sub

In "Lavoro nuovo" is combobox name: nuovaedizione

To filter in Combobox Ruolo in "Lavoro nuovo sub" I put this criteria:
Forms![Lavoro Nuovo]![Lavoratori].Form![nuovaedizione]

But I not receive list looking for and receive "Enter Parameter Value"
Somekind of reference is wrong