cookiejar
asked on
MS ACCESS 2010 VBA loop through multiple recordsets and update a recordset with a value
Could you give me an example on how to set and loop through multiple recordset
Set Recordset1 = Select Statement
Loop through Recordset1
set Recordset2 = Select from table where column = Recordset1.column
Loop through RecordSet2
concatenate Recordset2.column into hold_variable
hold_variable =hold_variable+ "," + RecordSet2.column
End loop
'How do I set up a recordset to update a value in a table?
Update a column in table with hold_variable
End loop
Set Recordset1 = Select Statement
Loop through Recordset1
set Recordset2 = Select from table where column = Recordset1.column
Loop through RecordSet2
concatenate Recordset2.column into hold_variable
hold_variable =hold_variable+ "," + RecordSet2.column
End loop
'How do I set up a recordset to update a value in a table?
Update a column in table with hold_variable
End loop
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.