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

Filter Information via combo box

P: 7
How do you get a combo box to filter the information a user can select in another combo box.

Basically i have a orders form where users select a location from a combo box. i then have a second combo box to select the sub location.

I want the user's selection in the first combo box to then only display the sub locations for that location in the second combo box.

I know there is a simple way of doing this but i cant remember how to.
Feb 12 '08 #1
Share this Question
Share on Google+
1 Reply


Expert 100+
P: 634
How do you get a combo box to filter the information a user can select in another combo box.

Basically i have a orders form where users select a location from a combo box. i then have a second combo box to select the sub location.

I want the user's selection in the first combo box to then only display the sub locations for that location in the second combo box.

I know there is a simple way of doing this but i cant remember how to.
Hi

You need to have a WHERE condition in the second Combo Box RecordSource based on the value selection in the first Combo.

In the AfterUpdate event on the first Combo you need to Requiry tthe second Combo.


HTH


MTB
Feb 12 '08 #2

Post your reply

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