Okay, I know this is probably a noob question but here goes:
I have a database with 17 fields, and one of the fields is a true false
I have a form with 16 textboxes, and 1 checkbox, and 2 buttons
What I want to do is when I open the form, got to row1 in the database, and fill in the data into the corresponding textboxes (and the 1 checkbox for the true/false field in the database) If I press the next button, it moves on to the next row, and if I press the save button, I want it to copy the textboxes back into the corresponding fields in the database in the same row as it was in (i'm just saving the changes)
If I have 5 rows in my db and i get to row 6 by pressing the next button, I want all the textboxes to go blank (without getting an error message) and make it create a new row and copy the data to the database in the new row when I press save
I have a database with 17 fields, and one of the fields is a true false
I have a form with 16 textboxes, and 1 checkbox, and 2 buttons
What I want to do is when I open the form, got to row1 in the database, and fill in the data into the corresponding textboxes (and the 1 checkbox for the true/false field in the database) If I press the next button, it moves on to the next row, and if I press the save button, I want it to copy the textboxes back into the corresponding fields in the database in the same row as it was in (i'm just saving the changes)
If I have 5 rows in my db and i get to row 6 by pressing the next button, I want all the textboxes to go blank (without getting an error message) and make it create a new row and copy the data to the database in the new row when I press save
