Setting Default Value to Previous Record Value

[dulla]

hello. i am trying to set the default value of a field (client score) to the value of this field in the previous record. how do i do this? the table that this field is a part of is called Counseling Session and it is on the many side of a one to many relationship with a table called Clients. thanks.

ameen

 

[Rolliee]

I disable the navigation buttons on the form and use my own. Then on the cmdADD buttoon, I use the following code.

sub cmdADD_click()
dim savr as whatever

savr = me.whatever
docmd.gotorecord,, acNew
me.whatever = savr

exit sub

This populates the new record with a value on the last one. Other manipualations of similar kinds can be made.

rollie@bwsys.net