How do I keep values on form data entry

wildpetals

New Member
Joined
Jun 3, 2008
Messages
2
Hi.
I have a form that I want the values from the prior record to stay there unless I change it.

The form saves data on enter (default form for access wizard)

How do I get it to keep the value of some of the fields to the prior record.

(the form tracks attendance of employees to a class, so I have a roster and I just want to enter the employees who attended and their score. I don't like having to type all this stuff in over and over and over again! :)

Thanks for your help. I really appreciate it.
 

Excel Facts

Who is Mr Spreadsheet?
Author John Walkenbach was Mr Spreadsheet until his retirement in June 2019.
Hi, and welcome to the Board!

One option is to use the Tag property of each control whose values you want to carry. This thread shows how.

Denis
 
Upvote 0

Forum statistics

Threads
1,215,727
Messages
6,126,521
Members
449,316
Latest member
sravya

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top