Report Offensive Message

Default values for Access form
You can use the following Code in the form After update event:
Field1.DefaultValue = """" + Field1.Value + """"

field2.DefaultValue = """" + field2.Value + """"

field3.DefaultValue = """" + field2.Value + """"

This will replace the default values by the latest values entered on the form at each record insert.
Posted by cmelhem@...
25th Oct 2011