so I was pretty excited to figure out how to use the before update macro to register the last touch user and date for any record that was edited in my forms.
When I embedded one form within the other as a subform, the before update event no longer fired on the subform. There is no option to create an update event for the subform to enter a USERID or NOW into the specific fields if anything on the subform is edited.
I need some help because I am getting a little frustrated as ive hit a wall
, and do not command a veteran SQL knowledge base to script my way out of this.
Any advice or help would be greatly appreciated