Adding records to a table using a data entry form
Adding records to a table using a data entry form
(OP)
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 --
DoCmd.GoToRecord , , acNewRec
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.
DoCmd.GoToRecord , , acNewRec
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.
jgarnick
jgarnick@aol.com
RE: Adding records to a table using a data entry form
Have you first checked to see if the record is valid?
RE: Adding records to a table using a data entry form
Any other ideas? It seems so basic! How do other people add multiple records to a table??
Thanks!
jgarnick
jgarnick@aol.com