Create new macro based off entries in form?

[angelaw]

Have a form/table that lists information, for each record I need to create 3 macros, one mom, dad and other. Right now manually creating 3 macros for one attorney. Is there a way that if a record is added or modified that it will automatically create (if new) or change existing macros that apply to the one attorney's initials? e.g. Jane Doe attorney has macro D-JD, M-JD, O-JD (dad,mom,other & initials). Want when users make changes to the main attorney list to either update or create macro based off info entered.

TIA
Angela

 

[ordendelfai]

I am confused and do not understand the question. I first do not see why you would have to make such a huge amount of macros. Macros function can be named in one saved macro, so you can call different functions of that macro.

I have a feeling you should be using Make Table queries of some sort, but I really don't understand what you are trying to do, so I can't help much =(

I'll try if you rephrase though =)