How can I display "last record" information on a form in add mode.
I have a set of 50 variables to input to an Excel calculation via an Access form, the variables then being stored in an Access database. Although all these variables have the potential to change, in reality only a handful of them actually change from calculation to calculation.
What I need to be able to do is display the last record values as a default setting on the form, whilst the act of opening the form will create a new record.
Any ideas?
I have a set of 50 variables to input to an Excel calculation via an Access form, the variables then being stored in an Access database. Although all these variables have the potential to change, in reality only a handful of them actually change from calculation to calculation.
What I need to be able to do is display the last record values as a default setting on the form, whilst the act of opening the form will create a new record.
Any ideas?