Wizard won't create subform

[Jessica]

Not proficient in access - I keep getting an error message
saying "wizard is unable to create form". Table name is
only 11 characters, and table has roughly 100 fields.

 

[Hugh O'Neill]

Not proficient in access - I keep getting an error message
saying "wizard is unable to create form". Table name is
only 11 characters, and table has roughly 100 fields.

That may be too many Table Fields for the wizard to cope with - I
forget what the limit is.

However, having 100 Fields in your Table strongly suggests you have a
faulty design to your data structure. I think you need to normalise
your stucture, in which case you will have more than one Table using
one-to-many relationships and be using main and subforms.

Look these subjects up in Help, watch this newsgroup and read a few
books, is my advice.

hth

Hugh