Hi there!

I'm new to reports and want to create some report versions of the forms I've already created. My forms all have quite a bit of VBA behind them.
To create a report, I've copied a form and re-saved it as a report object type. The VBA behind looks exactly like that of the original form however. Should I be doing something like changing the word 'Form' when it appears to 'Report'? For eg. Should I change:

Sub Form_Load()
On Error GoTo Form_Load_Err

to:

Sub Report_Load()
On Error GoTo Report_Load_Err

??

Thanks in advance for your help,
Catherine

I would say that, Yes, you might want to change those so they don't seem off, but I'll tell you that you should really come up with a generic naming for your error handler so that it doesn't matter where you have it, it is all the same. Then it really doesn't matter. I use MZ Tools (free) which allows you to set up an error handler the way you want it and then you can just go to the procedure and click a button and it adds it in.

Just remember to ONLY copy the parts in between the Private Sub SubName_Event() and the End Sub. Do not copy the titles as Access manages those and it doesn't like it when you mess with its events.

What would be the point of using forms vba on a Report when the two are entirely different beasts?