Access each row of subform

[Rattlesnake]

hi,
In Access 97,how can I access each row one by one in a subform where the "Default View" property of the subform is set to "Continous form".

Basically I want to update other tables , once the user has finished entering all records in the subform. These updates will depend on the individual rows in the subform. So i need to access them one by one.

Thanks

 

[Tiro Cupidus]

Let me make sure I understand...
You have a subform that accepts input and when the user is finished, that information is output to different tables depending on what was input?

 

[Rattlesnake]

Let me explain........
I have a form and a subform related like for eg an Invoice with the header and its details.

Now the user enters the rows (which will be prodcuts of the invocie) in the subform. Once he has finished entering as many rows as he wants, he can click "Save" button which will then store the records in the Invoice detail table and effect other tables like the "Products table" etc.

Basically I want to prevent the records in the subform to be added to their linked table as soon as they are entered, but should be saved on the click event of a button.

Thanks