Inserting passed data in to a SQL string 1

[Binnit]

I have the following function in a module:-

Public Function AddRiskDetailsToHistory(TempPolicyNo As String)

I am building an INSERT sql string and need the "TempPolicyNo" parameter to be part of the string but keep getting syntax errors or no result, my sql looks like this:-

Dim strSQL As String
strSQL = "INSERT INTO tblRiskDetailsHistory 
etc etc
" FROM tblRiskDetails" & _
" WHERE (((tblRiskDetails.EXPPolicyNo)= TempPolicyNo));"

DoCmd.RunSQL (strSQL)

What is the correct syntax for the WHERE clause to reference TempPolicyNo?

" WHERE (((tblRiskDetails.EXPPolicyNo)= TempPolicyNo));"

Any help appreciated.


If IT ain’t working Binnit and Reboot

 

[mp9]

" WHERE (((tblRiskDetails.EXPPolicyNo)= " & TempPolicyNo & "));"

http://www22.brinkster.com/accessory/

 

[mp9]

Or if the TempPolicyNo is not solely numeric:

" WHERE (((tblRiskDetails.EXPPolicyNo)= '" & TempPolicyNo & "'));"

http://www22.brinkster.com/accessory/

 

[Binnit]

MP9
Thats done it...thanks a bundle, the syntax always catches me out and never sure how many " or ' or & and in which order they are required.

Are there any simple rules to follow regarding syntax use in these SQL statements?

Anyway star for you for saving me loads of time and frustration!


If IT ain’t working Binnit and Reboot