Too many fields in forms

[Carrie]

Hi,

I have created a number of tables in a database. I am
attempting to create forms for the staff to use to enter
their information and print out reports. There is one
main table which contains relevant information for each
record. All the other tables have a relationship with the
primary key in this table.

I have created queries that include the appropriate info
from the main table and one other table (ie. table 1,
table 2...) I have up to 100 fields in a query. The few
small queries (approx 20 fields) create forms no problem.
The larger queries come up with an error message that
there are too many fields. Am I over the limit for the
number of fields or is something else happening here? I
really need all these fields on the same forms! Any
suggestion? Thanks a lot

 

[Rick Brandt]

Hi,

I have created a number of tables in a database. I am
attempting to create forms for the staff to use to enter
their information and print out reports. There is one
main table which contains relevant information for each
record. All the other tables have a relationship with the
primary key in this table.

I have created queries that include the appropriate info
from the main table and one other table (ie. table 1,
table 2...) I have up to 100 fields in a query. The few
small queries (approx 20 fields) create forms no problem.
The larger queries come up with an error message that
there are too many fields. Am I over the limit for the
number of fields or is something else happening here? I
really need all these fields on the same forms! Any
suggestion? Thanks a lot

You are only hitting the limit for the form wizard. Just don't use the wizard to
create your form. It's pretty useless anyway.