F
Fev
I can run this append query, as a query without errors. I have copied
this into code for a command button, from the SQL view and get a Type
mismatch error:
SQL1 = "INSERT INTO tblLSMDetail ( ProjectLSM, ProjectArea, ProjectID,
ProjectEthnic, ProjectGender, ProjectAgeGroup )" & _
"SELECT tblProjectLSM.ProjectLSMID, tblProjectArea.ProjectAreaID,
tblProjectLSM.ProjectID, tblProjectEthnic.ProjectEthnicID,
tblProjectGender.ProjectGenderID,
tblProjectAgeGroup.ProjectAgeGroupID" & _
"FROM tblProjectArea, tblProjectLSM, tblProjectEthnic,
tblProjectGender, tblProjectAgeGroup" & _
"WHERE (((tblProjectLSM.ProjectID)=[Forms]![frmSampleBuilder]!
[ProjectID]))"
I would greatly appreciate some help.
Thanks
Heather
this into code for a command button, from the SQL view and get a Type
mismatch error:
SQL1 = "INSERT INTO tblLSMDetail ( ProjectLSM, ProjectArea, ProjectID,
ProjectEthnic, ProjectGender, ProjectAgeGroup )" & _
"SELECT tblProjectLSM.ProjectLSMID, tblProjectArea.ProjectAreaID,
tblProjectLSM.ProjectID, tblProjectEthnic.ProjectEthnicID,
tblProjectGender.ProjectGenderID,
tblProjectAgeGroup.ProjectAgeGroupID" & _
"FROM tblProjectArea, tblProjectLSM, tblProjectEthnic,
tblProjectGender, tblProjectAgeGroup" & _
"WHERE (((tblProjectLSM.ProjectID)=[Forms]![frmSampleBuilder]!
[ProjectID]))"
I would greatly appreciate some help.
Thanks
Heather