Hey all! Is there a limit to the amount of recordsets you can use for a page? I am creating a form that updates my ITRequest table. To complete the form I need to create about 5 recordsets. 4 of them are simply tables used for various drop down lists for the update form. Every time I add my 5th recordset my update form will start missing fields. It will stop displaying my description and remarks field. To fix the problem, I created a static list instead of pulling the list from a table but I would rather not.

Any ideas?

Thanks in advance!

<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>Is there a limit to the amount of recordsets you can use for a page?<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>
No, no limits except if your computer crashes from like 999 recordsets, but that hasn't happened yet. <img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle>

<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>I am creating a form that updates my ITRequest table. To complete the form I need to create about 5 recordsets. 4 of them are simply tables used for various drop down lists for the update form. Every time I add my 5th recordset my update form will start missing fields. It will stop displaying my description and remarks field. To fix the problem, I created a static list instead of pulling the list from a table but I would rather not.<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>
Check the naming of each Recordset, make sure none are the same or something small like that. Are any Recordsets dependant on a Recordset (dependant dropdowns)? If so, again, check your variables/naming convention.

Let us know if you spot anything.

&gt;&gt; Check the naming of each Recordset, make sure none are the same or something small like that. &lt;&lt;

Nah, that sounds too much like work... next!
Okay, okay I will check. Just so you know, you are starting to sound like my boss. <img src=../images/dmxzone/forum/icon_smile_big.gif border=0 align=middle>