Allow access forms to retain data last entered

[Emmanuel]

I have an access form which is not linked to any table.

The form has some few vba codes behind it which basically that’s some calculations of which the results will not be stored.

I will like to get the data I last entered be the data to be displayed when I load the form afresh.

For example:

If I have three fields : Basic_Salary, tax and Net_Salary.

When i enter the basic_salary, the vba code helps calculate the tax and the net_salary.

If I close the form and open it, I will like to see the basic_salary, tax and Net_salary I last calculated displayed on the calculator as last calculation made so I do a new calculation.

Is this possible with access database?
If it is, how do i go about it.

Thank you.

[Minty]

The really simple answer is to store the data in a new unrelated table, and simply bind the form to it.
Set the form to single record, remove the record selectors, and make sure the forms cycle property is set to Current record.
Other form level settings should be don't allow deletions once the initial record is populated and data entry set to no.

Your form will always open on the first and only record.

[Emmanuel]

The really simple answer is to store the data in a new unrelated table, and simply bind the form to it.
Set the form to single record, remove the record selectors, and make sure the forms cycle property is set to Current record.
Other form level settings should be don't allow deletions once the initial record is populated and data entry set to no.

Your form will always open on the first and only record.

Noted.
Well give it a try and see how it goes.
Thanks

[Emmanuel]

I tried your suggestion and it worked.
Thanks so much for your time