I've got two combo boxes on a subform. The second combo's list is determined by what's selected in the first combo by using the following code in its rowsource property.
SELECT DISTINCTROW [tp_id], [Tech_Product] FROM [tbl_Tech_Type] where [tc_id] = [forms]![frm_client_tech]![tc_id];
(I refresh the form after the first combo is updated)
This works great when the form stands alone (ie.. not a subform). But when I add it to another form as a subform, the [forms]![frm_client_tech]![tc_id] isn't returning a value so everytime I open the form, I get asked for its value.
Any suggestions on how to correct this?
SELECT DISTINCTROW [tp_id], [Tech_Product] FROM [tbl_Tech_Type] where [tc_id] = [forms]![frm_client_tech]![tc_id];
(I refresh the form after the first combo is updated)
This works great when the form stands alone (ie.. not a subform). But when I add it to another form as a subform, the [forms]![frm_client_tech]![tc_id] isn't returning a value so everytime I open the form, I get asked for its value.
Any suggestions on how to correct this?