Reference individual records of a continuous form Access 2000

[briansmithdanisco]

I have a continuous form that has a record source of an existing query. Based on a tag setting in the form, the query can return one to many records for the form to display.

How can I loop through the records that are displayed in the continuous form? I need to write out the records that get displayed to a different table and also add some additional data that will be added to some of the records being displayed in the form. I was going to use VBA to update the second table, but I do not know how to loop through the listing and pull the data for each line from the continuous form.

Thanks.

 

[Remou]

You can use the RecordsetClone property to create a recordset to loop through, however, it may be quicker to create an append query from the RecordSource.