How to OPTIONALLY limit one combo box on another

[sfindlay]

Hi,

I have a form whereby I have two comboboxes, SUPPLIER and APPLICATION. The APPLICATION list is limited to the SUPPLIER in the first combobox.
Sometimes however I don't remember who the supplier is and would like the second box to be usable if no SUPPLIER is selected ie all the APPLICATIONS are available in the list.

Any ideas on how to do this?

[Scott Price]

Hi,

I have a form whereby I have two comboboxes, SUPPLIER and APPLICATION. The APPLICATION list is limited to the SUPPLIER in the first combobox.
Sometimes however I don't remember who the supplier is and would like the second box to be usable if no SUPPLIER is selected ie all the APPLICATIONS are available in the list.

Any ideas on how to do this?

In your Application combo box, I'm assuming you have the RowSource set to something like this:

Select ApplicationID, AppName From tblApplication Where tblApplication.SupplierID = Me!cboSupplier

One idea is to programmatically change the RowSource on the click of a button.

Me!cboApplication.RowSource = "SELECT ApplicationID, AppName FROM tblApplication"

Regards,
Scott