Variable Pass to new record

M

Mohammed

Can somebody help me to pass a variable to one record which is search and
selected.
For Example
on one record I have startCoupon = 101 then add 5 on this StartCoupon then
it will become startCoupon will be 106
Then we search another record and select the record
I want the StartCoupon value automatically show in textbox as 106
Please help me to make it possible.
 
A

Arvin Meyer [MVP]

On the next record, set the DefaultValue property to:

= DMax("FieldName", "TableName")
 
Top