Make-table

Can a command button macro run a make-table query with an auto-inputted parameter value?

I want to run a make-table query with a parameter, using a command button click event on a form showing a single record. The parameter value needs to be inputted automatically using the value of a control in the current record of the same form. Can this be done with a macro event? If so, what...