eof plus 1

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi
I have a temp table which data is entered into from a form. Once all the
details have been keyed and a cmd button is clicked the data from the temp
table is copied into the main table with additional data.

the problem I have is how to make sure that the very last record is also
added to the main table as at the moment with my Do ...Loop Until rs.eof the
very last record is not copied over.

I need to somehow tell the program to do the last record also without having
to duplicate my code for copying the data over.

Thanks
Noemi
 
Hi
Dont worry about this I worked out that I need to do the Until rs.EOF at the
beginning ie do until rs.eof.

Thanks
Noemi
 
Back
Top