I am new to Access and I am working on a form that populates a table. when I make an entry into the form it populates the table starting with the first row and overwriting the information already there.
I want the form to create a new row and add the information.
Also when I open the form it always populates with the text from the first row instead of blank.
Eventualy there will be error checking to ensure that there are no duplicate entries based on two fields.
I have searched a bit online however because I am so new I am still learning the correct vernacular.
I want the table to populate a new row every time as well as not show already entered data
Set the form's property DataEntry to: True