Quote Originally Posted by Ruegen View Post

I don't quite understand...
Instead of a huge and complicated SQL string for your DAO you could grab only the fields you need. Maybe a yes/no to edit, an email address, a name, and an ID.

With a recordset clone of a form's recordset, you could go through your second SELECT query, using the PK like a Master vs Child link. You can nest your second recordset inside the clone and loop through them both. Each .Movenext with the clone would be nested with a .Findfirst. The find first would use the WHERE criteria.

.Findfirst "[ID] =" & rsClone![ID]

or something like that. I would have to look at some of my example code to verify the syntax