Loop in Textbox

[new@this]

Hi All,

I have a form where a textbox has shows the NameNo from the NameNo column in a db. At the moment Im using a dlookup to set the textbox = to the NameNo, but obviously this is only returning the 1st value in the column. Can anyone please assist me on how to get this form to automatically display each NameNo, creating a pdf of the form and then moving on tto the next nameno.

I have the code to make the pdf working so far, all I need now is to figure out how to use the textbos to loop through all the NameNo's in the table.

 

[MarkK]

Your code is in that other thread right? You need to not use the DLookup(). Use values out of the recordset. Check out your other thread, I modified your code a bit.
You can post back there if you have other questions about it.
Cheers,

 

[new@this]

Thanks alot for your help man, but I need to save more than one file. For every NameNo the should be a PDF created with the NameNo as the name of the PDF file

 

[pr2-eugin]

Did you try the code that lagbolt provided in the other thread?