If you're doing it as on entry after another then you could create a public variabel and store the value of the last entry in it. Otherwise you'd need some sort of "find the last record and dump it in" kind of thing. As in creating a recordset, going EOF and reading it into your form