too many options for a drop down box on form

  • Thread starter Thread starter S. Peeples
  • Start date Start date
S

S. Peeples

Ok, I am really new at this but I have managed to develop a simple database
for my work but 2 of the form entries I wanted to make drop down boxes for
the sake of idiot-proofing and search ease have too many options for Row
Source to handle. Is there a work around?


Thanks in advance,
S. Peeples
 
S. Peeples,
I'm not sure what you mean by...
...have too many options for Row Source to handle...
Click to expand...

If you mean that the SQL statement string behind the combos RowSource
are too long, and the SQL is cut off?
Save the query. Example... save it as qrycbo1
Then indicate
qrycbo1
in the Rowsource of the appropriate combo box.

Otherwise, please describe in more detail what you mean by...
have too many options for Row Source to handle...
Click to expand...
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."
 
On Wed, 12 Aug 2009 19:33:01 -0700, S. Peeples <S.
Ok, I am really new at this but I have managed to develop a simple database
for my work but 2 of the form entries I wanted to make drop down boxes for
the sake of idiot-proofing and search ease have too many options for Row
Source to handle. Is there a work around?
Click to expand...

Do you mean that there are more than 65536 rows in the combo box? If so,
that's vastly more than would be reasonable for a user interface in any case.
Or are you using a "List of Values"? If so, consider creating a (small, few
hundred row max) table and using a Query sorting that table alphabetically
instead, as the basis for the combo.

Please explain the actual situation.
 
S. Peeples said:
Ok, I am really new at this but I have managed to develop
a simple database for my work but 2 of the form entries I
wanted to make drop down boxes for the sake of idiot-
proofing and search ease have too many options for Row
Source to handle. Is there a work around?
Click to expand...

I assume you are using a Value List that got so large as to be unmanageable.
As John suggested, putting the values in a table, and using the Table (or a
Query against the Table) as Row Source on the Combo Box should work
better... if you leave the "Autoexpand" property at the default value of
"Yes", then the dropdown list will automatically scroll as you type into the
box.

Larry Linson
Microsoft Office Access MVP
 
Back
Top