Abyss

Hi guys,

I'm working with Access at the minute and have run into a problem. Basically, what I'm trying to do is create an 'add new record' button that will copy certain field values from the old record into the new record. For example

So in the first record the name, gender and mileswalked are typed in. Then the 'add new record' button is clicked and only the name and gender values are copied.

I'm trying to do this using and ADO recordset but not having much success. Any suggestions would be a help. Thanks!