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.
Discussion on:
Message 2 of 7
0
Votes
Default values for Access form
Posted by cmelhem@...
25th Oct 2011
