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

Dependent Combo Box question

P: 3
Good morning. I have a contacts database that tracks the regular things like phone numbers, address etc. User searches for contacts through a combo box that lists entires by last name.

I've successfully added a dependent combo box that shows all of the first names for the entries of a given last name. For example, there might be 6 entries in the database with the last name "Brown" but only one entry "Sherwinas".

Is it possible for this dependent combo box to only be visible when it's needed, ie more than one entry for a selected last name? Many thanks for the help.
Nov 14 '07 #1
Share this Question
Share on Google+
1 Reply

Expert Mod 10K+
P: 12,373
Sure, in the same event that you cascade your combo box, run an appropriately constructed DCount() and if that's larger than 1, hide the box, else unhide it.
Nov 14 '07 #2

Post your reply

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