The error your getting would come from the table's design, not the form
design. Open the table in design view, click on the field in question, and
look at the bottom part of the window to see if Required is set to Yes.
Moving from Excel, I recommend that you take a good look at the example
databases, such as Northwind.mdb. You shouldn't have everything in one
table. Access is a "relational" database. To get the most use out of it, you
place related groups of data in their own tables with a field that links
them to the other associated tables. The most common of these is what is
known as a one-to-many relationship. For this, one table would have
information on, for example, companies, and a second table would have
information on employees. There would be a one-to-many relationship between
the companies table and the employees table (assuming none of the employees
worked for more than one of the companies).
--
Wayne Morgan
MS Access MVP
"Decreenisi" <cy*********@hotmail.com> wrote in message
news:11*********************@g47g2000cwa.googlegro ups.com...
Hi, First time using Access instead of excel (oh what have I done !!).
I am trying to set up a list of contacts, name address ect. I have a
table called "data", which has the raw information. I have even done a
report using a wizard to show the data. My problem is in forms, I have
a form to view and enter data, so far so good. When I have completed
the relevent fields and click on the small icon at the bottom left of
the page for a new record, I get the following error msg.
The field 'Data.4th childs name' cannot contain a Null value because
the Required property for this field is to true.Enter a value in this
field.
I have then changed the view to design, right clicked on 1st childs
name and looked at the properties. I can't see any difference between
1st & 4th Child.
Any suggestions ?