Syncronised Combo boxes

[CRO]

Anyone got any coding to help with the above. I want to
be able to select a subject the choose from the three
modules asociated with that subject.

Have set up two tables and linked them as follows
Sub_ID Mod_ID
Name Name
Sub_ID

Made a query for subjext fields (no criteria) and another
for Module ( sub_ID has criteria [Form]![Frmselector]
[qrysubselect]

Set up form called Frmselector and created two unbound
combo boxes.

The subject combo code as follows

Private sub.cbosubselect_afterupdate
Me!cbomodselect.requery
Me!cbomodselect.setfocus
end sub

The module combo as follows

Private Sub Form_current
Me!cbomodselect.requery
End sub

However this doesn't work and I don't know why.

Any help appreciated

 

[James Goodman]

[Form]![Frmselector]![qrysubselect]

Should be:
[Form]![Frmselector]![cbosubselect]