I am building a multi-step data entry process. In the first few steps, the data entry person is entering in new records for multiple tables. In the latter steps, they will be adding to these records. The problem I am encountering is as follows:
I have a command button that opens a new form. I wrote a basic code to goto to the last record. However, the form is not going to the most recently entered record. Access is using the foreign key in the table to determine the last record. However, I want to use the primary key to determine the last record since each new record will get a primary key with a progressively higher number.
How do I force access to use a specific column of data to determine the goto last record?
Thank you
Matt