Subform Linking Problem - Automation error

[Jason1971]

Hi,
My attached database contains a problem with the linking of the subform "SubFrm_Projects_Highlights" to the MainFrm. When entering data into the subform (while nested in the main form) I get an automation error.
I want to link the subform so that it is filtered by Staff Name and Year (comboboxes on the MainForm). My apologies for not being clearer or giving more detail...it's clearer in the attached database. Thank you for any help.
(Separate question: Why can't we upload Access 2007 files?)

 

[SOS]

(Separate question: Why can't we upload Access 2007 files?)

You can - just zip them first (which you should really do regardless).

 

[Jason1971]

I've tried to fix my linking problem but it is a really tricky problem. I cannot find any way of getting my child fields to autopopulate as they should (because they are based on parent fields of unbound comboboxes). i.e. the user selects a staff member from a Staffcombobox and a year from a Yearcombobox and then the (child) records in the subform need to be linked to this staff member and year from the mainform.

I am going to have to populate the child-linking fields manually using VBA code. To achieve this I need to declare some sort of "Global?" variable that works between forms. Can anyone tell me 1)what is the proper name for such a variable (so I can read, in the online help, about how to use/apply it) and 2)where do I type/create this variable so it works between forms? Thank you for your help.