Form length limit and how to create multiple forms from one table that link to the primary key

[HackerMan]

I am very new to access - I have many variables in one table and I need to add more to the form I've created.


As the length of the form is set to 22 inches, I am unable to add the other fields I have left passed this point.

So my question is: how can I create another form or continue this form so that I can add the additional fields, while still linking to the one primary key ID ?

Do you have to create a new table and make a new form?
Would appreciate any insight!

[ranman256]

forms are pretty infinite, you can just keep adding fields to the bottom.
Tho if you have 255 fields (or more) then the table design may be wrong.

[June7]

Use Tab control to organize other controls.

That's an awful lot of fields. What is the data structure?

[HackerMan]

I have about 70 field (variables) in one table ... I want to use Access so those doing data entry can enter data into an actual data set.

I need to relate all 70 fields back to one ID, but I can only add about half of the fields before the length limitations of the form cut me off...

How can I create one form, or multiple forms, that will allow me to enter data for the one table? do I have to create separate tables and separate forms - in this case how do I link the forms and tables to the one ID?

[June7]

Did you try suggested solution?

Didn't really answer question.

[isladogs]

I have about 70 field (variables) in one table ... I want to use Access so those doing data entry can enter data into an actual data set.

I need to relate all 70 fields back to one ID, but I can only add about half of the fields before the length limitations of the form cut me off...

How can I create one form, or multiple forms, that will allow me to enter data for the one table? do I have to create separate tables and separate forms - in this case how do I link the forms and tables to the one ID?

Not sure I understand completely and maybe I'm missing the point here.
If you use a 'single' form layout with one record on the screen at a time, you shouldn't have any issues

[Minty]

As already suggested a Tabbed form is the answer.
You can have many tabs, but they are actually all only one page of your form, and the controls are (can be)bound to the same record.

And as others have suggested 70 fields is quite a lot for one record to have in a normalised data set up.(Not impossible though)
Can you post up a field list for the table?

[Missinglinq]

...I have about 70 field (variables) in one table ... I want to use Access so those doing data entry can enter data into an actual data set...

This sounds an awful lot like what we refer to as 'committing spreadsheet via database!' Also, as has been suggested, the 70 fields to a single Table is also suspicious for a well designed, normalized relational database.

We really need to see a list of these fields, as Minty suggested, in order to give you
best advice.

Linq ;0)>