Would like to copy a record found on a search form to a addNew form

[jmk0576]

I have a project search form that can display multiple records based on multiple criteria. Would like to add a button which would allow the users to add a new project record with the values of the project selected on the project selection form. Not sure how I copy values from one form to the other. Do I need to specify each individual field or can I "clone" the selected record and add as new. Fairly new with all of this so any help will be greatly appreciated.

Thanks,
Julie

[June7]

I would make 1 form serve both purposes.

How many fields? Could run an INSERT SELECT sql action to first save record to table then open form filtered to that record. Something like:

CurrentDb.Execute "INSERT INTO tablename(ProjectNum, field2, field3) SELECT " & Me.NewProjNum & " AS PN, field2, field3 FROM tablename WHERE ProjectNum=" & Me.ProjectNum

[jmk0576]

Thanks, I'll give that a try.