Moving Subform Data

[Lewis825]

Hi Guys & Gals,

VBA Noob here so bear with,

I have a Subform displaying data from 2 tables which is filtered via a qry depandent on a value in a text box on the form.



the aim is to moved the filtered results into another (3rd) table on the click of a button.

Hope this makes sense?

thanks in advance

[cyanidem]

DoCmd.RunSQL "INSERT INTO ThirdTable SELECT FROM FilteringQueryGoesHere"

[Lewis825]

Super,

I have tried this before will little luck

here is the qry that runs the subform and filters the results

how will i word this in the DoCmd.RunSQL command?

Cheers