make table from form recordset

[johnLH]

HI all

I have form containing some filtered records. What code do I need to put on a button to trigger a make-table query; the make-table thus containing only the current filtered records (not the entire database).

The following will use the entire database:

Dim stDocName As String

stDocName = "qryMakeTableCompanyID"
DoCmd.OpenQuery stDocName, acNormal, acEdit


Thanks

John