Insert record in one table and it inserts a record in another

[Guest]

I have a main form that when i create a record in it i need it to create a
record in another form that will include the first records key value in the
second forms key value field. help please, thanks in advance

 

[John Vinson]

I have a main form that when i create a record in it i need it to create a
record in another form that will include the first records key value in the
second forms key value field. help please, thanks in advance

This is NEVER either necessary nor is it a good idea. Creating such
empty "placeholder" records does you no good at all!

Instead, make the second form a Subform of the first one, using the ID
as the master/child link field. Then when you actually enter data onto
the subform, the ID will fill in for you automatically (but not until
you need it).

John W. Vinson[MVP]