Conditional combo box

[vavs]

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?

 

[SydneyGeek]

There's no hidden event that lets you uncouple the second combo; you need to change the rowsource in code. Here is an example.

Denis

 

[vavs]

Thanks Sydney. That is what I ended up doing. I have the if statement to check for the value in the combo boxes and if they are both either null or blank(someone may have deleted the value) then I list all records otherwise I select based on one or both of the combo boxes.