Displaying last record values as a default setting on a form in add mode

A

Andy McCulloch

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Print oreview multiple records 8
Default Value on Form Help 1
Calculating averages on a form 3
Access ADP Form and Stored Procedure as RecordSource 0
Access ADP Form and Stored Procedure as RecordSource Options 2
How do I obtain a value from an external form? 3
Access 2007 Tabbed form with shared recordset 0
Add-in question: can I store default values for a form in the Add-in? 3

Top