Advance Recordset and Trigger a Function...?

[CliffHanger9]

hi all -

I have a form with a lot of records in it ( > 150)

on this form is a button which generates a word document report based on the info in the form

I need to create a macro/function that will trigger the report generation function advance the form recordset and repeat until it gets to the end.
(in word i have a document_open event which will send the report to the printer spool and close doc)

I think this is a simple thing to do but i dont know enough VBA to acomplish this recordset advance, and call function... probably on somekind of loop or something?

Any help is greatly appreciated in advance!!!!!!!!!!!!!!!!!!1

Cheers-
Dan

 

[CliffHanger9]

nevermind then.