Cannot open more databases - new question

[bhipwell via AccessMonster.com]

I am getting the 3048 error: "Cannot open any more databases." I have a
couple forms loaded with tabs covered in combo boxes, list boxes, etc. The
error occurs when running a form with 12 subforms on it.

The form and subforms all reference the same table (they are separate forms
so I can use the visibilty function to move data vertically when necessary).
This fact I think elimiates Table IDs being created due to too many queries
or tables being opened.

So...it has to be all the combos, lists, etc., right?

My question, however, if I have combo boxes that only reference value lists
as a row source, does this count as a table ID? I don't think it would, but
before I go rebuilding stuff, I wanted to check.

Thanks!

BH

--
Message posted via http://www.accessmonster.com