Sometimes I need to copy some values from a current record into a new record. I know i can duplicate the record but this copies everything. Also I want ot be able to visually flag that we are now in the new record and that te user has to fill in fields x,y, & z to complete the new reocrd as it is easy to confuse the new and old records. how should i approach this?

thanks

You can do something like that:

If Me.NewRecord = True Then

Docmd.RunSql ("INSERT INTO EmployeesHistory (FirstName, LastName, Title)
VALUES (Forms!Employees!FirstName, Forms!Employees!Lastname,Forms!Employees!Title);")

else
Msgbox("You are viewing an existing record now")

End If

I hope this will solve ur problem.

Cheers!
Aqif