can't edit control

[jalge2]

Hi all, I have a form containing detailed information about a person. It also has 3 check boxes in which one is checked depending on what department they are in. Receiving, Shipping, Building.

Inside this form is a subform that has a combo box and some check boxes. Anyway, if the shipping check box is checked in the main form then the tblshipguide is the controlsource of the combo box. When I run this, the combo box is showing #Name? and hit the down arrow, it brings up the correct list but it's giving me this error at the bottom of the screen:

Control can't be edited, it's bound to unknown field 'task list'.

Below is a list of my code.

Forms!frmqualcard!Check10 = False
Forms!frmqualcard!Check12 = False
Forms!frmqualcard!Check14 = False
If Forms![form: Training Master]![Dept] Like "B*" Then
Forms!frmqualcard!Check10 = True
Forms!frmqualcard!frmqualcardsubform.Form![Task List].RowSource = "tblbuildguide"
Forms!frmqualcard!frmqualcardsubform.Form![Task List].ControlSource = "task list"
ElseIf Forms![form: Training Master]![Dept] Like "R*" Then
Forms!frmqualcard!Check12 = True
Forms!frmqualcard!frmqualcardsubform.Form![Task List].RowSource = "tblreceiveguide"
Forms!frmqualcard!frmqualcardsubform.Form![Task List].ControlSource = "task list"
ElseIf Forms![form: Training Master]![Dept] Like "S*" Then
Forms!frmqualcard!Check14 = True
Forms!frmqualcard!frmqualcardsubform.Form![Task List].RowSource = "tblshippingguide"
Forms!frmqualcard!frmqualcardsubform.Form![Task List].ControlSource = "task list"

 

[Eupher]

Any time you refer to field names that include spaces, you must enclose them in brackets. I think = "[task list]" is what you want for your ControlSource properties.

HTH,

Ken S.