Hello All,

I am new here and need some help as I do not know VBA. I have a basic template form that has a "batch number" field. My dept uses a lot of these forms so I need a macro that will print the form and then upate the batch number field with the next number that is listed in another column and then print again. It would also be helpful if I could specify how many copies I would like to print.

Any help would be greatly appreciated.

I have attached the basic form.

Thank you!