default value

[Bill]

I need a default value in a field to be the last reading
from another record. The database has a subform that
records hours a piece of equipment is used. The hour
field contains a start reading and an ending reading.
from this I arrive at a total running time for the
equipment. I need the next start reading on the next
blank record to have the ending reading from the last
record.
Thanks Bill

 

[Jeff Boyce]

Bill

One approach to handling this is to change the value of the form's default
property for that control. You could do this in the form's AfterUpdate
event, setting [YourControl].DefaultValue = the value you just entered.