I am using MS Access 2013 in an attempt to create a Form-driven database.
Suppose I have 2 forms-- I enter data into several Text Box's in Form One, then, using a Control Button ('Next') I open Form 2 and continue entering data into that form's Text Boxes. The idea here is to have a string of Forms from which I can enter data, and that data is saved to the same record in a Table.
The problem I am facing is that data entered into Form One is placed in Record 1 on my Table, while data entered into Form Two is placed in the next Record (Record 2).
Question: How can I create a string of Forms, but have the data inputted into each of those Forms show up on the same Record in the same Table?
*Note: I do not want advice that starts with the phrase "Why are you doing it that way..." Let's just assume that there is a reason my program has to work this way. If you can help me out with this problem-- without deviating from scenario presented; it would be MUCH appreciated.