Default field to previous value 1

[stuandwil]

Is it possible to populate a field with its previous value. A record is added every hour, a product is chosen from a drop down. 98% of the time it stays the same but every now and again the product will change.

 

[PHV]

In the AfterInsert event procedure of the Form set the DefaultValue property of the product to it's actual value.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[stuandwil]

not sure how to implement what you say, I have this but not working as yet.

Private Sub Form_AfterInsert()
[cboproduct].DefaultValue = cboproduct
End Sub

 

[shelspa]

Create a query that shows only the last record. In the default value of the control on the form you can do:
=DLast("fieldname","qryMost_Recent_Record")

 

[stuandwil]

many thanks, I have it working from your example.