In order to Carry the values of certain fields from the current record into the next new record I want to insert this code into an event of my FORM:
fld_1.DefaultValue = "'" & fld_1.Value & "'"
fld_2.DefaultValue = "'" & fld_2.Value & "'"
fld_3.DefaultValue = "'" & fld_3.Value & "'"
Now, which event would be the best - BeforeUpdate, AfterUpdate, etc.? I have one book that suggests BeforeUpdate, and a Website that suggests AfterUpdate, and another Website that suggests putting it in a command button to conditionally execute it.
Also, can you think of any pitfalls to using this method to repeat field values?
Karl
fld_1.DefaultValue = "'" & fld_1.Value & "'"
fld_2.DefaultValue = "'" & fld_2.Value & "'"
fld_3.DefaultValue = "'" & fld_3.Value & "'"
Now, which event would be the best - BeforeUpdate, AfterUpdate, etc.? I have one book that suggests BeforeUpdate, and a Website that suggests AfterUpdate, and another Website that suggests putting it in a command button to conditionally execute it.
Also, can you think of any pitfalls to using this method to repeat field values?
Karl