VBA changes and saving a form as a report

[cath_hopes]

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

 

[boblarson]

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.

 

[Rich]

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