Is this possible

[pigsie]

Hi I would be grateful if anyone could give me any pointers on how to do the following:

I have a form which displays the results of a parameter query - I would then like to launch a second form ( I can do that) which iterates through the records on the first form.

Is this even possible?

Thanks

 

[PHV]

Take a look at Recordset

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[hwkranger]

Yup, very possible.

As PHV said use a recordset. You should IMHO bind your form to the recordset that you want, then you can navigate the recordset as if it were any regular query. (in truth they are one and the same thing..)

Randall Vollen
National City Bank Corp.

 

[vbajock]

You might also want to look at recordsetclone as well.

 

[pigsie]

Thanks, I will have a look into this