Too many controls on single form 1

[Wiznane]

Hi,
I have a set of forms, all with many option groups in them. For most of these forms, the controls stayed well below the maximum 754 limit. However, I have one that ends up having way more than that. The underlying table is very close to the 256 limit of fields as well.
Now this is more of a design question, I suppose, but what would be a good way to go about getting this to work? All the forms are laid out with the option groups broken up via a tab control. I was thinking that I would have to break the table up and then use subforms in each tab control page. Is this the best solution?

Thanks in advance for any help. [sig][/sig]

 

[TheBlade]

I'm having the same problem. Does anyone have a solution?

 

[Chance1234]

sub forms sounds the best way to go, have you thought though of doing the fron tend in VB ?

would be interested to know why you have 256 fields in your table as well , there must be a way of cutting that down ive worked on many db's and think the largest i have seen has been about 60 and that was cut down to about twenty

 

[Sameal]

Instead of using tabs you could make buttons that go to each of what you have as tabs now. But instead of going to a tab, have them open a completely new form. This form could then have all the options relating to that tab, and when your done you can click a Close button to go back to the original form. I do this trick often as I HATE the tab control in Access as it looks gawd awful when you try to do custom formating to the general layout of your forms.