How can I run the Make_Table Query without having the following warning message pop up on the screen?.
"You are about to run a make-table query that will modify data in your table" .................

Run the query from vb ...

With Docmd
.SetWarnings False
.OpenQuery "MyMakeTableQueryName"
.SetWarnings True
End With

Thanks again Kevin, that would work!.