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

Hi,

This is because "subform" is no longer in the Forms collection, but the "mainform" is.

You can change the SQL to use
[Forms]![mainform_name]![subform_control]!maincategorycombobox].

Alternatively, you could update the subcategorycombobox's rowsource property with the actual value of the main category in the AfterUpdate event of the maincategorycombobox .

HTH.

Malc.

darn! of course! named it properly and it solved the problem. Thank you. B