View Single Post
  #6 (permalink)  
Old January 11th, 2007, 01:12 PM
mmcdonal mmcdonal is offline
Friend of Wrox
Points: 9,611, Level: 42
Points: 9,611, Level: 42 Points: 9,611, Level: 42 Points: 9,611, Level: 42
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Mar 2004
Location: Washington, DC, USA.
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts
Default

Well wait a second. You are creating a recordset, then updating it (which saves it.)

When you use this line:

SICE04_Pro_InformationTable.AddNew

you are adding a record to your recordset.

I think if you move the AddNew line into your loop, then you would achieve what you want here. While it is outside the loop, it seems to me it can only add one record during the first loop. After that, it should keep updating the same added record, so that you only see the last record in the last loop.

If should have this syntax:

Do While Not SICE04_Data_LocationsTable.EOF

   SICE04_Pro_InformationTable.AddNew
   ...
   SICE04_Pro_InformationTable.Update

   SICE04_Data_LocationsTable.MoveNext
Loop

Did that help?


mmcdonal
Reply With Quote