hiya guys just a quick one, i was wondering if you could help. (im new to access so bear with me :D )

i currently have 5 forms each with its own set of records (from a linked excel list) and each form has a button for each month of the year - pressing it will take you to the first record of that month. i have a macro to do this but it only works on the original form and as there are 12 months i was trying to avoid 60 odd macros just on one fuction.
i was wondering is there any way to copy them and change which form they work on or if there is any way f a macro running on multiple forms (for example i tried putting 2 form names into the field but it didnt work)

cheers guys
hope to hear from you!

Qoo

My first thought would be to convert the macro to VBA, this can be done with the DATABASE UTILITIES under TOOLS. Then you could call this module from every form, and include varibles if neccessary.

yup - that seems to have cracked it :) cheers jeremie! I was really not looking forward to having 60 + macros!!

thanks

Qoo