Navigating Records in a form

[Alasdair]

I need to reference data held in a form (or the underlying
table) when running a query.

Each record in the form / table holds criteria information
for a single query which will return different results for
each record. I need to pass each criteria set to a new
instance of the query, but I can't seem to access the
individual criteria when more than one record is selected.

The detail records are on a datasheet form and are
selected by setting a check box on the record to
true.

I need to cycle through each record on the form testing
the check box for each record and if true run a report
passing criteria from other fields on the same record to
the underlying query.

I can't see how to cycle through the records on the form,
the Do...Loop and If...Then constructs are
straightforward.

I know this can be done, but I don't know how !!

Any help appreciated.

Alasdair