What EXACTLY does the error message say? How many fields are in the form's
Record Source? The usual message is that Access can't create a form because
there are too many fields, which means just that. The forms wizard is
intended to help the casual user create a simple form. Complicated form with
bunches and bunches of fields doesn't fall under this heading. These forms
have to be created using the Form Design View.

Signature
There's ALWAYS more than one way to skin a cat!
Answers/posts based on Access 2000/2003