On Oct 5, 2:08*am, Fev <hgos...@worldonline.co.za> wrote:
> 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 is a duplicate - my apologies - my laptop "was hanging" after
posting :-(
|
