I want to create a database that will add new records individually but there are so many attributes that I needed to use 5 different forms rather than one very large form. I am having trouble having the 2nd, 3rd, 4th and 5th forms add the new values to the existing row.
Right now I have an EMPLOYEE table where a new employee is added. The next forms all add information but I need them to update the existing row using the unique ID number that an AutoNumber.
I want the second form to access the record that was created with my first form. Can I have an Update Query that automatically edits the most recent record added?