Too many fields in forms

  • Thread starter Thread starter Carrie
  • Start date Start date
C

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
 
Carrie said:
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
Click to expand...

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.
 
Back
Top