Last record default

[AndyMcC]

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?

 

[bat17]

Here is some code, it is old and not well formed but it works

Sub Up_Date()
Dim This_Form_Name As String
Static pc As String
Static bat As String
Static pn As String
Static v As String

On Error GoTo update_error_trap
This_Form_Name = Screen.ActiveForm.Name
DoCmd.GoToRecord acForm, This_Form_Name, acLast
 pc = Screen.ActiveForm![Product Code]
 pn = Screen.ActiveForm![Product Number]
 bat = Screen.ActiveForm![Batch Number]
 DoCmd.GoToRecord acForm, This_Form_Name, acNewRec
 Screen.ActiveForm![Product Code] = pc
 Screen.ActiveForm![Product Number] = pn
 Screen.ActiveForm![Batch Number] = bat
 Screen.ActiveForm![Product Code].SetFocus
 Screen.ActiveForm![Product Number].SetFocus
 Screen.ActiveForm![Roll Number].SetFocus
update_error_trap:
End Sub

this code works from a hotkey but it should give you some ideas.

HTh

Peter