By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,827 Members | 2,220 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,827 IT Pros & Developers. It's quick & easy.

How to OPTIONALLY limit one combo box on another

P: 3
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?
Sep 20 '07 #1
Share this Question
Share on Google+
1 Reply


Scott Price
Expert 100+
P: 1,384
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:
Expand|Select|Wrap|Line Numbers
  1. Select ApplicationID, AppName From tblApplication Where tblApplication.SupplierID = Me!cboSupplier
One idea is to programmatically change the RowSource on the click of a button.
Expand|Select|Wrap|Line Numbers
  1. Me!cboApplication.RowSource = "SELECT ApplicationID, AppName FROM tblApplication"
Regards,
Scott
Sep 20 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.