DataMacro - Creating a record in a table based on 'FOR EACH RECORD' command.

[Tracyd]

I have a parent/child form (document) which runs a datamacro to create records in a third table , based on the records on the child form.
I have tried the "FOR EACH RECORD...." on the child form, and included the "CREATE A RECORD...." within that data block.
The error message i'm getting is "CANT USE A CREATE RECORD " within a 'FOR EACH RECORD" block ???


The table i'm running the datamacro from is the third table. Any suggestions please ?

[June7]

Is this a web-database?

I never use macros unless absolutely have to (twice) and haven't tried the new data macros.

Alternative is VBA code in an event procedure of form or a control on form.