I have a stored procedure that I use to fill in a combobox on a user form. I like the fact that this box uses AutoExpand to finish off what the user is typing, however, I don't think that it is working with the entire range of possible values. When I run the proc in my Access project it defaults to 10,000 records. How can I bump this value up? I tried doing it with the slider on the bottom but that doesn't save it. And there are no properties for stored procs as far as I can see. Is there some way to put it right in the proc?
Red Flag Submitted
Thank you for helping keep Tek-Tips Forums free from inappropriate posts. The Tek-Tips staff will check this out and take appropriate action.
Reply To This Thread
Posting in the Tek-Tips forums is a member-only feature.