Demonstration of a For Next Loop within a Recordset Loop. The Recordset Loop provides the start and end values for the For Next Loop. The For Next Loop calls a function which insert the data into a table. The whole system is designed to quickly and easily create sets of Records dependent on some criteria stored in a table. The code was initially created in answer to a specific question on Access World Forums. I realised that it was an excellent example of using a Recordset Loop and a For Next loop together.
More information See my blog HERE:- http://www.niftyaccess.com/create-many-records/