OK, I find that I am typing a rather long string in many "notes" section of the subform. Rather than have to type this over and over again, I would like to automate this procedure. So I have tried to create an "Event Procedure" to accomplish this, but so far, the coding doesn't work as I would like. Here is what I have done so far:
Event Procedure = AfterUpdate
Expand|Select|Wrap|Line Numbers
- Private Sub Form_AfterUpdate()
- If NFA_Pre_Reveiw_Sent = "Foreign" Then [form.Web Review.Memo] "Per Jane Pfeiffer, NFA Compliance, no Web Reveiw needed"
- End Sub
Can anyone please help me figure out why the event procedure doesn't work?
Thank you!