Stuart McLachlan
stuart at lexacorp.com.pg
Sat May 6 07:35:24 CDT 2006
Correction: > > ...'Fill recordset rs with Project table > .... > While not rs.eof > strDevelopers() = split(rs!DeveloperNames,";") > For lngLoop = 0 to UBound(strDevelopers) > strSQL = "Insert into tblDevelopers (Project,Developer) Values (" & _ > rs!Project & ",'" & strDevelopers(lngLoop) & "')" > ......'write new record using the SQL string > Next > rs.movenext > Wend > -- Stuart