Duplicate Record

[aker]

Hi,

I have a record and want to be able to duplicate it with a click of a button but incrementing the revision number. I am very new to VBA and would appreciate some help.

The following records being a composite primary key: project, orginator_code, recipient_code, discipline, doc_code, mtg_no, revision

I have thought this may have been on the right track from the research i have done but it gets an error:
DoCmd.RunCommand acCmdRecordsGoToNew
Me("Project") = .Fields("Project")...

A link to a print screen of the form:

i48.tinypic.com/bek5h.png

 

[pwbrown]

This should help: http://allenbrowne.com/ser-57.html