can i use a subform for adding records in table

[Guest]

Hi,
I have a form for adding new records for each employee. I want to add a
subform for adding about 10 records at the same time for one single employee.
The form row source is another table. Is this idea possible?

 

[Guest]

What do you mean by adding 10 records?

Adding a sub form to a main form you can add much more then 10 records, if
you want the records added to the sub form linked automatically to the
employee in the main form, then set the child and parent properties of the
sub form to the ey field that link both tables

 

[Guest]

Hi,
What I meant is who to store the records at the sub form into another table

thanks!

 

[Rick Brandt]

Hi,
What I meant is who to store the records at the sub form into another
table

Like any other form a subform will save its data (and retrieve existing data)
from whatever table you use as its RecordSource.