I have a Company combobox and Contact combobox. The RowSource for my Contact dropdown is all contacts. However, if a company is selected I want the Contact dropdown to only show the Contacts at that company. I have the correct syntax for this critiera that I added to my query:
But how do I deal with no value selected in the Company combo? I want it to go back to showing all Contacts...I just can't figure it out.Code:[Forms]![F_QUOTE]![cmbCompany]