Page 1 of 1
Created a new DB but I cant enter info
Posted: Fri Mar 24, 2017 5:36 pm
by Miked0l
I created a new DB and created a table and a form using the wizards, I go to enter info into the form and keep getting error messages (Error inserting new record) SQL status 23000 Error code 10. I have no clue what to do to fix this as ive tried several times. Any suggestions?
Re: Created a new DB but I cant enter info
Posted: Sat Mar 25, 2017 12:24 am
by Villeroy
Re: Created a new DB but I cant enter info
Posted: Sat Mar 25, 2017 4:58 pm
by UnklDonald418
Does your table have a Primary Key?
The safest approach is to use the default Primary Key, which is an integer named ID set to auto increment.
Also note that the Primary Key field must be on your form. It doesn't have to be visible, but it must be there if you want to use the form for data entry.