Open form, filtered, then copy records

[andrewf10]

Im trying to create some code which will open a form, filtered to specific query criteria and then copy each resulting record to a new record while a field called 'Complete' has a value of True.

Can someone please suggest some ways of doing this? I have a query which selects the records. Should I convert this to SQL and run it within the form. Or do I leave the query as is and refer to it?

Any help greatly appreciated,
Andrew