subform combobox problem
Hi - I've been tearing my hair out with this, so I hope someone can help.
I have an access 2007 mdb front end which links to a sql 2008 server instance.
I have created a main form which holds data pertaining to cases, on this there is a continous subform holding information about people and is incorporating two tables, table people and table contact info. the info on people includes ethnicity info which is spread over three combo boxes, main category, subcategory and other. these comboboxes are fed from three different tables, however, the choices in the subcategory combo box are dependent on what was chosen in the main category. so, in the after update event of the main category I put a me.subcategorycombobox.requery event. the sub category combobox is sourced by by a "select all where maincategoryID is like [forms]![subform]![maincategorycombobox]".
Now this all works fine when I open the subform on it's own, however, when opening the main form with the subform on it, the comboboxes cannot display correct data and throw me a parameter request instead. none of the requerying seems to be happening either. I have no idea what the problem is, so would really appreciate any help. Thank you. B