February 24th, 2014, 08:21 AM
Do while loop
Can anyone please help me with a Do while Not loop.
I'm very new to programming:
I need to check and print a list, and limit it to 5 names.
Do While Not rsP.EOF And iCount > 5
sLT = sLT & rsP![Name] & vbNewLine
iCount = iCount + 1
If rsP.RecordCount > 5 Then
sLT = sLT & "..."
right now it will not print the list, if I take out iCount > 5, it prints, but I need to limit it to only 5 names maximum to print?
Tags for this Thread
Click Here to Expand Forum to Full Width