On your Access form's load event (or similar) use the movelast function, then an addnew function to get to the last record, then add a new one.

(sorry, I didn't try it out...)

HTH

Tom