build continuous form on screen, when complete insert all record into table

[mdavid]

Hi,
I have a main form with a subform SubA- single record, SubA contains a second subform SubB which is a continuous form. In this continuous form I want to be able to add edit and delete records on screen without writing to a table. When the continuous form is complete I want to insert all the records into a table. Is this possible or would I need to use 2 tables - a temporary table to hold the continuous form records and a second table that I would transfer the records to when the continuous form is complete?

Thanks for any help


David

[June7]

If data is not in table then there are no records. Why would you save to a table to just then copy records to another table?

[mdavid]

Thanks for your quick reply, just trying to get my head around what I want to do. I understand what you're saying whatever's on the screen exists in a table.

[June7]

Whatever's on screen exists in table if the form is bound to table or query.

[Missinglinq]

...would I need to use 2 tables - a temporary table to hold the continuous form records and a second table that I would transfer the records to when the continuous form is complete...

Yes...that is the standard approach for this type of thing, but this is a complicated approach, and should only be taken if there is a really compelling reason for doing so, rather than simply using a Bound Form to begin with!

Why do you need to do this?

Linq ;0)>