I don't believe you you need the for next loop. All that is necessary is:
private sLastname as string
do until rs.eof
rs.fields("Lastname") = sLastname
rs.movenext
loop
To prove the efficacy put this before the loop
Msgbox slastname
Make sure that you have only a few records...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.