Adding records to a table using a data entry form

[jgarnick]

I am having trouble adding more than one record to a table using a data entry form.&nbsp;&nbsp;I have a form that is set up to be a data entry form (data entry property set to yes).&nbsp;&nbsp;On this form is a command button to add another record--here's the code the wizard created --<br><br>DoCmd.GoToRecord , , acNewRec<br><br>The form is based on one table.&nbsp;&nbsp;When the form is opened it displays a blank record--once you fill it in and click on the command button to add another record, you get a message about being at the end of a recordset and can't go to the specified record. <br> <p>jgarnick<br><a href=mailto:jgarnick@aol.com>jgarnick@aol.com</a><br><a href= > </a><br>

 

[JTRockville]

You'll get this message if the record shown on the form doesn't pass validation criteria. For example, there may be validation rules for a field that this record doesn't meet, or it might create a duplicate record, etc.<br><br>Have you first checked to see if the record is valid?<br>

 

[jgarnick]

Good point, but that wasn't it--the text fields in the table had the &quot;Allow zero length&quot; set to no and I changed them all to yes.&nbsp;&nbsp;There is only one required field and I have made sure that it is filled in before trying to add another record. I also tried entering data in all the fields also.<br><br>Any other ideas?&nbsp;&nbsp;It seems so basic!&nbsp;&nbsp;How do other people add multiple records to a table??<br><br>Thanks! <p>jgarnick<br><a href=mailto:jgarnick@aol.com>jgarnick@aol.com</a><br><a href= > </a><br>