too many fields defined

[hbaggs]

I have a large form consisting of five TABS which is populated by a query. The query is accross a number of tables however all the fields it queries it does need to complete the one form. Fundamentally how do I break down the query into smaller numbers of fields when I need all information to present to calculate the totals for a certain report.
thanx

 

[neileg]

Your design sounds suspiciously poor. However, you could have a main form and use buttons to open pop-up forms. Each of these forms could be based on a separate query, and this would enable you to reduce the size of the queries and number of controls on a form.

 

[Kraj]

Or each tab could have a subform on it, which would be controlled by a seperate query, rather than tossing more fields directly onto the tab