Inserting records with form value as column

[vmon]

I am trying to insert records into a table and want to use a form control as one of the columns. This is what it looks liek right now.

strSql = "INSERT INTO tblRate ( ModelId as " & strQuote & Forms!frmCopyModelRates!cboToModel & strQuote & ", " _
& "RateNumber, Activity, RateDriver, Rate, Basis ) " _
& "SELECT tblRate.ModelId, tblRate.RateNumber, tblRate.Activity, tblRate.RateDriver, " _
& "tblRate.Rate, tblRate.Basis " _
& "FROM tblRate"


CurrentDb.Execute strSql

thanks,
vmon