Hi
I have a (frm_Main) with one combo box "cbm_Main". In the combo box after update event I would like to open (frm_List) which also have a combo box "cbm_List"
Both combo boxes has the same control source "qry_Departments" and the bound column is 1. The content are numeric values.
I would like frm_List to open with the same combo box selection as I choose on frm_Main, but I cant seem to get the where condition syntax correct.
Something like:
docmd.OpenForm "frm_List",acNormal,, <cbm_Main=cbm_List>
I have a (frm_Main) with one combo box "cbm_Main". In the combo box after update event I would like to open (frm_List) which also have a combo box "cbm_List"
Both combo boxes has the same control source "qry_Departments" and the bound column is 1. The content are numeric values.
I would like frm_List to open with the same combo box selection as I choose on frm_Main, but I cant seem to get the where condition syntax correct.
Something like:
docmd.OpenForm "frm_List",acNormal,, <cbm_Main=cbm_List>