Run a VBA script When a form opens

[WickidWe]

Hi,

I know it will be a simple answer but how do I set a VBA script on a form opening?

[June7]

Code in the form Load, Open, or Current event.

[WickidWe]

Perfect Thanks

One more thing off topic
I want a button to Run a specific report then print
can you help? or should I just make a new thread?

[June7]

DoCmd.OpenReport "report name here"

will send direct to printer.

Access VBA Help has more info on using OpenReport (or OpenForm) and its arguments.

[WickidWe]

Thank you