June7, Thank you RunCode worked. Why use macros? Because I don't know any better. I inherited a colossal mess and was asked to try to fix it. There are a lot of embedded macros used. They worked in most case so I didn't try to fix them.

For example a lot of the subforms have delete button to delete the associated record. It's click event is tied to an embedded macro which contains all of this mash which I have no idea how to replace with VBA.

Embedded Macro.jpg

I am a fair hand with Word VBA but Access at this point is a bit over my head.