ExcelBanter - View Single Post - PrintOut and PrintPreview show only first record when printed using ADO and VBA

[email protected]

Hi
your code would help.

regards
Paul

wrote:

Hi,
I'm trying to print a batch of forms based on the records I read from
the db table.
I have my recordset and fields are filled with each iteration in excel
spreadsheet
Debug.Print indicates that form values do change, but when I print or
display printpreview through the code, the only first record shows when
I loop through the records.
What am I missing here?

I am using Excel 2003 in case it matters.
Thanks.
Alex