You would base your form on a QUERY which can contain several related
tables. Just breaking this into two pieces is not the answer though.
Sounds like your structure is badly flawed. Sounds like you should have
several one-to-many relationships.

What is in this table? What is the structure of your data? If you have
things like...

Salary2004 Salary2005 Slaary2006

or

Hobby1 Hobby2 Hobby3

etc,

Then you want to stop, step back, and rethink your design. Those examples
point to cases where a one-to-many relationship should be used. This will
involve addind a new table with two fields. One for the person's
identification number, and one for their Hobby. Or, in the Salray example,
three fields. One for the ID, one for the amount, and one for the date.
These new tables would be related to the original table where the person's
information is stored.

Give us some detials about your data and we can give you some ideas.

--
Rick B



"blackcat" wrote in message
...
thanks for your response, so if i create a new table, how can i pull this
into the existing form that i have, ie how do i use two tables on one form
or
report. my calculations are stored in a macro, hense the reason for
needed
to have all fields on one form

"Rick B" wrote:

Just one more thought. You say it really needs to be in the same table
due
to complex calculations. Not sure what that has to do with it. You can
pull data from many tables into a query, report, and form to perform
calculations.

Hopefully you are not storing any of these calculated values in the
table.
With few exceptions, that is not recommended. Calculations should be
performed in the queries, reports, or forms. Storing them in the table
can
lead to problems if you need to change one of the numbers upon which your
calculation is based.

--
Rick B



"Rick B" Anonymous wrote in message
...
Ummm- you should redesign your table. At the most, you should have 20
or
30 fields in a table.

You may want to explain your structure so we can recommend how you can
improve it. Sounds like you are using Access as a Spreadsheet, not as
a
relational database. Doing so will cause you many many headaches.

--
Rick B



"blackcat" wrote in message
news i have created a database which has huge table, i need to add more
fields
to
this table (really does need to be in the same table as i have some
very
complex calculations going on too!) only i now get the message
'exceeds
limit
of 255 fields' is there any way i can over wright this?