run a command for each record from a selectionquery

D

den.hoppy

Hey, seem to got myself into a problem here.
I've got a report, which did its job fine until now.
Its form 2 tables (linked true an index on-to-many) and if I print it from
my form (with subform) it does its job well.
But now I want to print more then one record and used a query as source for
the report, but something seems to go wrong with the calculated values on
this report (form difrent record then from the printed record.
Didn't find the problem so I wanted to work around the problem.
I want to give a print order for each record in my selection query

What is the best way to doe this a loop untill ... and how do I best
do this
or is there a way with the recordsetfunction do while ..
I am trying the latter one but rather unsuccesfully, keep getting errors
(never used it before)

Thanks for your help
and forgive my language mistakes.
Belgian boy in trouble
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Trying to create a report that will list unmatched records by Ticket Primary Key 0
Copy previous record into form field 0
Improving Macro That Keeps First Letter 0
For Each Record 5
Inserting a beginning record in a subform 2
Automation of scanned file storage based on content 0
VBA works in orignal but fails in copy of database 1
Update multiple record values from form/query 1

Top