Is there a limit to the number of combo box?

[Guest]

I have a form to enter survey data with 60 combo boxes. Each has its own SQL
statement as row source. As I open each one in turn they work fine until at
some point I get msg "Unable to open any more databases." and the combo box
has no list to view. I presume that as I open form or open each combo box it
runs SQL and this remains open even after I move on to succeeding combo boxs
eventually using too much space. In its present form each combo box row has
its own unique ID# all from the same underlying query. The individual SQL
statements serve to limit which of these is offered to the user as each combo
box is entered. How can I work around this limitation?

 

[Dirk Goldgar]

I have a form to enter survey data with 60 combo boxes. Each has its
own SQL statement as row source. As I open each one in turn they
work fine until at some point I get msg "Unable to open any more
databases." and the combo box has no list to view. I presume that as
I open form or open each combo box it runs SQL and this remains open
even after I move on to succeeding combo boxs eventually using too
much space. In its present form each combo box row has its own
unique ID# all from the same underlying query. The individual SQL
statements serve to limit which of these is offered to the user as
each combo box is entered. How can I work around this limitation?

You've put your finger on the problem. I suppose you might try loading
each combo as you enter it and unloading it as you exit it, by leaving
the RowSource blank at design time and using code in the Enter event to
set its RowSource, with code in the Exit event to clear the RowSource
again.

On the other hand, have a look at Duane Hookom's At Your Survey
database, which is posted here:


http://www.rogersaccesslibrary.com/Otherdownload.asp?SampleName='At Your Survey 2000'

It's frequently posted here in response to questions about survey
databases. The description on the website says this:

<quote>
At Your Survey (ATS) is a full featured application that allows users to
create their own surveys by designing the questions and providing a
lookup of possible responses. ATS uses a fairly normalized table
structure so the same tables, forms, code, queries, and reports can be
used for any number of surveys. There is a brief manual to help you get
started as well as a sample survey with data.
</quote>