wizard won't create form

  • Thread starter Thread starter Jennifer
  • Start date Start date
J

Jennifer

I have tried creating a form using the Form Wizard, and
get an error message stating "The wizard is unable to
create your form." I have a couple of hypotheses as to
what the problem is, but I'm not sure what is the cause.
I'm trying to merge two different tables into one form.
The tables are related. Does Access not allow the use of
two tables in one form, even if they are related? The
combined number of fields for each table is quite
lengthy. Is there a limit to how many fields a form can
hold? Unfortunately, there's no way for me to cut the
number of fields because they are all components of a
research study instrument. The reason that I used two
tables was because the first table could not hold all of
the fields that I needed. Is there a way to combine two
forms without the wizard? From what I can tell of the
Design View method, there's no way to merge two different
tables. Please help!

Thanks,

Jennifer
 
Jennifer said:
I have tried creating a form using the Form Wizard, and
get an error message stating "The wizard is unable to
create your form." I have a couple of hypotheses as to
what the problem is, but I'm not sure what is the cause.
I'm trying to merge two different tables into one form.
The tables are related. Does Access not allow the use of
two tables in one form, even if they are related? The
combined number of fields for each table is quite
lengthy. Is there a limit to how many fields a form can
hold? Unfortunately, there's no way for me to cut the
number of fields because they are all components of a
research study instrument. The reason that I used two
tables was because the first table could not hold all of
the fields that I needed. Is there a way to combine two
forms without the wizard? From what I can tell of the
Design View method, there's no way to merge two different
tables. Please help!
Click to expand...

There is a maximum limit for the number of fields and if you have to use two
tables clearly that limit has been exceeded.

I'm guessing that your tables are not properly designed.
If you have fields that contain similar information you are doing it wrong.
Usually field names give us a clue. Something like Date1, date2, date3 is
an indication of a problem.

Access allows the use of one recordset at a time in a form. This may be a
table or a query based on one or more taboes. (or tables if you like.)
 
Back
Top