I would like to 'copy' a form and its linked subform(s) which contains our projects and related milestones to a new form. The functionality is similar to having a 'template' project - or 'save as' type document. Once the end user changes the project number, they can make changes to certain fields in the record.

I am not familiar enough the Macro actions to know how to attack this.

thanks for any help - !

You will need two queries that you can run from macros or code. The first query copies the record from the main form's table, the second copies the records from the subform's table.