I have a form with 3 combo boxes on it. Customer, Vendor and PO. I have the boxes set up to filter based on the information in the other boxes. Currently I have it set so that based on the vendor only the POs for that Vendor will show up. I also have the customer based on the PO. My problem is that now the users want to sort by the Customer independent of the Vendor or PO. The way I set this up is to build a query for the row source based on a value in the combo box. I then have an event set for on change to requery the next combo box.
What I want to do is have the Customer combo box come up with all customers initially and only requery if the PO is entered. Is there some event that I am missing and can I load values initially and then change them once a value is entered in the PO?
What I want to do is have the Customer combo box come up with all customers initially and only requery if the PO is entered. Is there some event that I am missing and can I load values initially and then change them once a value is entered in the PO?