Hello! I'm hoping someone can help me with this master/child linking problem. I have a form with 3 combo boxes that are used to filter information that is seen in a subform. Once the user has selected the filters from this form, they click a command button to apply the filter. The command button takes you into a form with subform. There are 3 fields (the same 3 on the filter form) on this master form. I am trying to connect these 3 fields with the same fields on the subform. The 3 fields are Business Unit, Business segment and Customer Name.
Right now I have connected the master and child with BU and BU_Seg. I have connected it with Customer_name also, but if this connection is in place, it will not give any data in the subform unless a Customer_name is selected also. The users will not always want to filter the data by Customer_Name. The filter works fine when it only uses BU and BU_Seg. when a customer name is selected, it doesn't filter it by the customer_name, it gives you the same results as the filter by BU and BU_Seg. How can I add this third filter without it being required to run the subform. please let me know if this explanation makes sense, and if you can help me out in any way.
Thanks in advance!!
Right now I have connected the master and child with BU and BU_Seg. I have connected it with Customer_name also, but if this connection is in place, it will not give any data in the subform unless a Customer_name is selected also. The users will not always want to filter the data by Customer_Name. The filter works fine when it only uses BU and BU_Seg. when a customer name is selected, it doesn't filter it by the customer_name, it gives you the same results as the filter by BU and BU_Seg. How can I add this third filter without it being required to run the subform. please let me know if this explanation makes sense, and if you can help me out in any way.
Thanks in advance!!
