So I have a Form Filter (main form filters subform results). One of the 5 combo boxes using Table\Query type for the RowSource is not working (I really hope I can attach my sample DB here, if not it is harder to explain)
So for each combo box (except the one not working), they directly pull their data from their respective fields now (which makes the Form Load up\Open faster since I have a Form OnLoad Event to prepopulate all combo boxes). When I changed over the combo box not showing results in subform, it doesn't want to find the results. I can give the SQL Syntax coming from Row Source.