I have a form that I am in the midst of creating.
On this Form there are several football club names (e.g. A1, B2, C3 etc.).
These buttons contain the Team List for the club. I have set a macro up to email the list to the relevant contacts for each Club.
But if some club changes the contact person, is there some way I can have the macro open in design mode on the form so that the end user (who may not be familiar with Access) can just change the email address. Or does this involve code, which I am not great with, but am trying to learn.
Any help is greatly appreciated.
On this Form there are several football club names (e.g. A1, B2, C3 etc.).
These buttons contain the Team List for the club. I have set a macro up to email the list to the relevant contacts for each Club.
But if some club changes the contact person, is there some way I can have the macro open in design mode on the form so that the end user (who may not be familiar with Access) can just change the email address. Or does this involve code, which I am not great with, but am trying to learn.
Any help is greatly appreciated.
