carry over previous inputs in form from last session??

[tmc]

hello,

I've got some vba code working great to carry over the previous inputs into the next record in a form to save putting it in over and over again when inputing multiple records.

However, is there any way to carry over the last input from the last session??

i.e. i have to exit and re-enter the form many times throughout the day and would like it to remember the inputs from the last time i was in a session on the form?

I've tried looking al over the net - but i'm a novice and i'm lost!!!

help would be really appreciated!

Many thanks.

tmc.

 

[Steve R.]

I created a table to hold default values. A similar approach can be used to hold the last entered values. This can be triggered when the form is closed or at the time the database is exited.

Upon re-opening the database the values held in the table can be assigned to variables. Or when the form is opened, the form reads the values contained in the table and assigns them to the appropriate text boxes.