Setting field default value to previous record field value

[KellyJo]

I have a form that I need to be able to set the default value of "Name" field to the value that is in the "Name" field of the previous record.

Example:

Name: Adam Bloomfield
Date Scheduled: 9/27/04

NEXT RECORD
Name: Adam Bloomfield
Date Scheduled: 9/28/04

I don't want to enter the person's name in every time I do a new record for them. Any suggestions?

Thanks!
KellyJo

 

[mph1]

Suggestion - instead of carrying the name forward, use a drop down for the name, unless you will only have one name.

Assuming there are many names -- Even though you may be entering many records for the same name, at some point there will be a another name. By doing such will help reduce errors of recording the incorrect name.

An investment in knowledge always pays the best dividends.
by Benjamin Franklin
Autonumber Description - FAQ702-5106

 

[KellyJo]

That would be okay, but I'm entering the person in like 15 times in a row, before moving on to the next and my users don't like having to select the name from a list of 875 employees everytime they need to add a new date for a person's schedule. Any other ideas? Thanks for that suggestion.

KellyJo

 

[mph1]

I understand your dilemma and am not sure there is any perfect solution. Look at the following, it may help you.

http://www.mvps.org/access/forms/frm0012.htm

Good Luck!


An investment in knowledge always pays the best dividends.
by Benjamin Franklin
Autonumber Description - FAQ702-5106