I have 2 combo boxes retrieve same source from one query in Main form. When user made a selection in Combo box 1 then Combo box 2, it will then search and match the criteria and load the result from the particular query into subform.
For example, I have 50 products listed in the query. A user selects Color in Combo box 1 then Size in Combo box 2, it will then update the subform to display the result in which product match the criteria of color and size. Do I need to add an Update command button or just use the After Update macros to do it? What are the coding to generate this? Many thanks for the help.