Best way to create new records from continuous subform

[longestdrive]

Hi
I'm trying to create a stock check form. I have a continuous sub form based on a query that lists all the products available and a text box for the user to enter the current stock levels in their stock check.

I now want to create a new table entry in the stock level table that is based on each row in the continuous subform and I don't understand the best way to do this.

Do I iterate through each row in the form or do it via the subforms record set. The text control where the stock level is entered is not bound to the query (would it be better to do that?)

If possible can someone point me in the right direction before I plough down the wrong road.

Thank you

 

[longestdrive]

Hi
I'm progressing my project - I've referred to the recordset of the subform nut because my stocklevels is an unbound control in the continuous form it does not appear in the record set.
So, I then added an expression in the underlying query for the stock level and bound the control to that value. However I can't now update the value of stock as it's based on an expression.
So, back to plan F. I reverted back to my unbound box - but when I update one box on the continuous form all the rest of the entries are updated as well.
Gradually sinking....
Can anyone point me to the correct way to do this please.
Thanks