Hi I am new to Access and am trying to create a DB to log time engineers spend performing tasks.
I have created a form which contains a pair of synchronized combo boxes, to allow the user to select first an Engineer Type, then an Engineer Name from a filter list of engineer type.
The method I have used to create this form works correctly, if the form is a parent form. (I used this method Sync Combo Boxes )
The problem occurs when i try to use this form as a sub form, inside another parent form. As soon as i open the parent form i get the following warning



And the form does not work as intended. Am I using completely the wrong method to get my Forms to do what i want?

No, it's just that you need to address the control one way if it is a parent form, and another way to address it if it is contained in a subform control:

Forms![NameOfForm]![NameOfSubformControl].[NameOfControlOnSubform]

Thanks for your help that fixed my error problem, but now I have hit another.
My sub form is in data sheet view.

1) when I select a value from the combo box 1, the combo box 2's list is filtered as I require.
2) and 3) When a 2nd entry is added, and the value selected in combo box 1 is different to that of the previous entry, the previous entries combo box 2 no longer displays the stored value.
4) If a third entry is added, and the same value for combo box 1 is selected as in entry 1, then the data in combo box 2 for entry 1 reappears, and the data in combo box 2 for entry 2 disappears.

All values are stored correctly in the table.
Is there a way to solve this problem, as it would be good not to have my information disappearing.
Attached is a screen shot of my problem

Thanks in advance