Hi,
I want to copy records of a mainform as well as records of the subforms by clicking the duplicate command (built by the command button wizard, which is on the mainform). The database is just taking the information from the mainform, but not those of the subforms. Any solution????

You will need to build a separate append query for the records of the subform's recordset (remember all the subform's rows may not be showing on the form).