Carry Data Forward

  • Thread starter Thread starter TeeSee
  • Start date Start date
T

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
 
TeeSee said:
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
Click to expand...

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)
 
Back
Top