I have a select query called 'qryDefineGrid'
On Click Event of a form button I wish to create another query based on 'qryDefineGrid' as though I had physically done a Save As, and then renamed it. Once done I would then want the user to be taken to Design View of this new query.
The new query would be named as the text that would be entered in a form a control[frmExport]![txtGridQueryName]
There does not appear to be a DoCmd.SaveAS ?
Developing in 2007 that is also used in 2010 environment.