How do I... Base a control's default value on data input?
Source: Susan Harkins
One of the most common ways to reduce data input is to provide a default value -- the most common value --for input controls. That way, when the value equals the default value, the user simply bypasses the control altogether. Occasionally, the default value becomes irrelevant as data changes. When that happens, you need a more versatile solution -- one that allows the data to determine a control's default value. Susan Harkins shows you how to create that user experience in Microsoft Access.
This download is also available as an entry in the TechRepublic How do I... blog.