The 'modifiedby' field is what I found on the forum, my field is actually
called 'User' and I am using it to capture what user is entering data into
the form. I want it to populate automatically when the user opens the form.

"Linq Adams via AccessMonster.com" wrote:

What is your point in placing it in the Load event? This will only cause the
fields in the first record that loads to be changed, and what if that record
isn't actually modified? It will now have erroneous information.

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000/2003

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...forms/201003/1

.