I am having trouble adding more than one record to a table using a data entry form. I have a form that is set up to be a data entry form (data entry property set to yes). 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. 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>
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Adding records to a table using a data entry form
- Thread starter jgarnick
- Start date
JTRockville
Programmer
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>
- Thread starter
- #3
Good point, but that wasn't it--the text fields in the table had the "Allow zero length" set to no and I changed them all to yes. 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? It seems so basic! 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>
- Status
Similar threads
- Locked
- Question
- Locked
- Question