Executing new controls blows up 1

[jjd100]

We have a 5-yr old Access 2003 application with about 400 controls. Late last year we could not create new controls, reviewed the postings on tek-tips reading about the 754 maximum and MSAccess's non-clean-up of old controls that have been deleted. We created a new form, copied and pasted the old contols onto the form, then copied and pasted the code associated with the controls. We can now successfully create new controls. After creating 3 new controls, we are having problems again. When the code is executed behind the new control, in this case to set a form variable to a new value, the application blows up with the "encountered an error" message, "do you want to send report to Microsoft?". Any help here would be greatly appreciated.

 

[Remou]

Have you considered subforms?

http://lessthandot.com

 

[jjd100]

we currently have 6 tabs and no subforms. I suppose we could put some new controls on a subform, food for thought, thanks.

 

[Remou]

It is quite possible to load a form into a subform control on click of a button. You can make the whole thing look like tabs. It makes for quicker forms.

http://lessthandot.com