Carry Data Forward

[TeeSee]

In a small 5 field form I am using to "take off" items for quoting
purposes how could I carry the same data forward to the next record
and the next until it is manually changed by myself and then that
change continues until changed again. This may only apply to 1 or 2
fields of the 5.

Thanks

 

[Stuart McCall]

In a small 5 field form I am using to "take off" items for quoting
purposes how could I carry the same data forward to the next record
and the next until it is manually changed by myself and then that
change continues until changed again. This may only apply to 1 or 2
fields of the 5.

Thanks

In the form's AfterUpdate event, copy the current field value into the
appropriate control's DefaultValue property. If the data is textual,
surround it with double quotes:

MeControlName.DefaultValue = Chr(34) & Me.ControlName.Value & Chr(34)

 

[Allen Browne]

See:
Assign default values from the last record - Carry data over
at:
http://allenbrowne.com/ser-24.html
for code you can use to do this in any form.