parametrized Queries

[blacksaibot]

I am looking for a good tutorial or sample code on parametrized queries in VBA.

I am creating a query based on results of another query... but one of the strings contains a single quote and destroys my second query and it cannot execute properly.

Private Sub getUserLeaderInfo(ByVal record As Long, ByVal rs As DAO.Recordset)
    With rs
        queryStr = "INSERT INTO t_user_ldr_info VALUES(" & _
            record & ", " & _
            "'" & .Fields("Controlp") & "', " & _
            "'" & .Fields("Test") & "', " & _
            "'" & .Fields("LoginID") & "', " & _
            "'" & .Fields("DTG_Submit") & "', " & _
            "'" & .Fields("PIN") & "', " & _
            "'" & .Fields("SystemID") & "', " & _
            "'" & .Fields("Role") & "', " & _
            "'" & .Fields("Mission") & "', " & _
            "'" & .Fields("Location") & "', " & _
            "'" & .Fields("Other") & "', " & _
            "'" & .Fields("Terrain") & "')"
    End With
                    
    DoCmd.SetWarnings False
    DoCmd.RunSQL (queryStr)

End Sub

How can I turn this into a parametrized query?
Yes, I've googled it... but I don't get much out of the crap that comes up in the results.

[June7]

Use replace function to double the apostrophe so code will recognize the literal character.

Replace(fieldname, "'", "''")

Replace(.Fields("Other"), "'", "''")

This syntax should work also:

Replace(!Other, "'", "''")

Are any of those fields actually number type? If so, don't use apostrophe delimiters. And date/time fields use # delimeter.