Code for Unbound text not working in Report Open Event

[bobleonard]

Hi,

I'm probably doing something dumb here but maybe someone can enlighten me.

I first put the code "Me.A0.value = Str(mylonga)" in the open report event. I get the error: cannot assign a value to this variable. Debug shows I'm reading the correct data in the table.

Next, I move the code to the 'Format Event' in the Detail Section.

If I double-click on the report name, I get the form with no values. But if i do a 'Print Preview' I get the data in the table.
(I can live with this)

This is a report with all unbound text controls. I'll actually get 3 records per page.

The last thing I'm unsure about is: After I get my first three records out. How do I Paginate..to do the next three pages.
Thanks for any help.
BobLeonrd

 

[bobleonard]

Sorry, I moved this question to Access VBA programming. Bob