Can Not Open Any More Tables

K

kaz

I have a form which was working fine. It was based on a table. When the form
was open I could double click on a specific field and open another form based
on a different table to show additional information. I added 5 new tables to
the database and changed the recordsource of the form to one of these tables.
Now when I double click on a specific field I get the error message "Can't
open any more tables". Any ideas ?
 
J

John Vinson

I have a form which was working fine. It was based on a table. When the form
was open I could double click on a specific field and open another form based
on a different table to show additional information. I added 5 new tables to
the database and changed the recordsource of the form to one of these tables.
Now when I double click on a specific field I get the error message "Can't
open any more tables". Any ideas ?
Click to expand...

There is evidently an error in the code (or perhaps macro) which is
being executed in the textbox's Doubleclick event. Without seeing the
code I can only make vague guesses at what the error might be (opening
tables without closing them???)

Please post the code.

John W. Vinson[MVP]
 
Top