Add a record to a table and confirm it was added - MS Access
Posted on 2016-10-11
I have an Access database with a form that has 3 textboxes (textbox1, textbox2, textbox3) and a command button.
I have an Access table (MyTable) with 3 fields (Field1, Field2, Field3).
I need the code that will write (i.e. add a record) the textbox data to the table (textbox1 goes to Field1, textbox2 goes to Field2, etc) when the command button is clicked and I also need to confirm that the record was actually added.