Create new record in sub form from main form

G

gazza

I need help with the code to create the first record in a sub form
when adding a new record to a form

I am using the after Update event of the main form
then testing to see if is a new record

If Me.NewRecord then

I need help with the cdoe to create a teh new record in the sub form

End if

The reason for this is I have a query over a number of tables and unless
there is
at least one record in each table then the results donot include all the
records I want
 
Top