View Full Version : Default value for data entry field


GeorgeS
03-23-2005, 05:19 AM
How can I set the default value equal to the value in the previous record?

Pat Hartman
03-23-2005, 02:24 PM
There is no built in tool to do that since in a relational database, no row is related to any other row and row order is undefined.

You can do it with code in your form though. Search the archives for samples but make sure that your table is properly normalized and that the data you are trying to duplicate doesn't really belong in a different table.