How to carry over date value from one record to the next.

[Nicole via AccessMonster.com]

I have searched this site and the internet in search of an answer to this
problem but none of the solutions I've found have seemed to help. I have a
form that is used for data entry. The first two text boxes are called
Supervisor and W/E Date. These two values will remain the same for several
dozen entries. I have tried just using CTRL + ' to repeat the data but that
is getting quite time consuming as well. How do I automatically carry over
the value to the next record once I input the first data in? Any help on this
would be much appreciated.

 

[ruralguy via AccessMonster.com]

See if this link helps some.
http://www.mvps.org/access/forms/frm0012.htm

 

[Dorian]

Place 2 unbound controls on your screen and make them invisible (visible
property = false.
In your Form's BeforeUpdate event, copy the values of Supervisor and W/E
date to these hidden controls.
In your Form's Current event, populate your Supervisor and W/E date from the
hidden fields.
-- Dorian
"Give someone a fish and they eat for a day; teach someone to fish and they
eat for a lifetime".