Hi,
I have a multitude of Combo Controls that I use throughout my database. They are usually based upon a query of some sort.
What I would like to do is have a Function that fires when the Combo is open that does the following:
1. Counts the records resulting from the underlying query (.rowsource).
2. Up to a maximum of 20 rows, dynamically change the ListRows # to reflect the number of records in the .rowsource.
This way, up to 20 records, my combos would always show the full result with no scroll bars (which is desirable).
Thanks!
Start Free Trial
