Totals Query in Dropdown

  • Thread starter Thread starter Bob Barnes
  • Start date Start date
B

Bob Barnes

Access 2000 - Using a Totals Query to populate a Dropdown
to display 7 columns.

Have learned it will not display all 263 Records returned
by the Query. It will display "less Records" - not sure
the "record limit" where the Display stops.

Input welcomed. TIA - Bob
 
As far as I am aware, it doesn't sound like a "record limit" problem. I have
had combo boxes displaying more than 400 rows without problems (other than
slightly slower performance).

Maybe if you can provide a little more information someone may have some
thoughts.

Good luck

Andrew
 
Yes, I was surprised as I have Dropdowns (with a non-Totals
Query RowSource) displaying 5000 Records.

I guess it's the "Totals" Query - still welcome input.

TIA - Bob
 
Access 2000 - Using a Totals Query to populate a Dropdown
to display 7 columns.

Have learned it will not display all 263 Records returned
by the Query. It will display "less Records" - not sure
the "record limit" where the Display stops.
Click to expand...

A Combo box won't instantly populate all rows when the form is opened.
If you scroll down, do more records appear? or if you type a value you
know to be near the end of the list, will it force a completion? You
may need to put some code in the control's GotFocus event to force it
to fill completely.
 
John - Just saw this.

A test reveals that YES (Thank you), entering the 1st
character of a value "not seen" will work.

Thank you, Bob
 
Back
Top