Number of Fields Exceeded

[tsn.s]

Hi

I have hit a bit of a roadblock with a database I am currently working on. I have a form that needs to have more than 255 fields on it which I know isn't ideal. The form it's self has a tabbed menu on it for different categories. The fields are linked to a query that pulls the information from several different tables. I don't know quite how to get round this. I've thought about sub forms within the main form but I haven't had much joy with them so far. I don't know if I have explained it very well, but I have attached a screenshot of one of my large forms.

Any ideas will be much appreciated.

Thanks

[RuralGuy]

There is a Lifetime limit of about 754 controls of any one form. You can exceed this limit by simply using SubForms on your MainForm.

[tsn.s]

Thanks, I didn't know that. I've tried splitting up my form into several forms. I think my problem is the total number of fields over my 9 tables. I know there is a 255 field limit in tables and queries and that you shouldn't really get to anywhere near that number. I can't link them together with a relationship as they don't have identical fields and I can't use a query because there are too many fields. I can link them together by having an ID field on each table where the user manually inputs a unique ID number that corresponds with the other table. However this is very inefficiently and is very open to user error. I can't think of any other way to got around this.