G
Glen
The following code is presenting a problem for me and I don't know
enough about SQL to correct it quickly. Any help would be appreciated.
I am trying to take the field values of a certain record and place
them into a temporary table. I need this to be done when the table ID
equals the current record in the form. The error is:" syntax error
(comma) in query expression "
strSQL = "SELECT
([SClss],[SHll],[VsNm],[FirstAvailDate],"
strSQL = strSQL & "[LastAvailDate],[AvailType],[UIC]) INTO tblSSHEADER
FROM User_Data "
strSQL = strSQL & "WHERE [ID] = & Me![SSelect]"
DoCmd.RunSQL (strSQL)
enough about SQL to correct it quickly. Any help would be appreciated.
I am trying to take the field values of a certain record and place
them into a temporary table. I need this to be done when the table ID
equals the current record in the form. The error is:" syntax error
(comma) in query expression "
strSQL = "SELECT
([SClss],[SHll],[VsNm],[FirstAvailDate],"
strSQL = strSQL & "[LastAvailDate],[AvailType],[UIC]) INTO tblSSHEADER
FROM User_Data "
strSQL = strSQL & "WHERE [ID] = & Me![SSelect]"
DoCmd.RunSQL (strSQL)