Forum Discussion
VBA to update email when rep name field entered issue
I have a form that contains a lot of fields, two of which are the "CSR Name" and "CSRemail". I would like the CSRemail field auto populated after the CSR Name field is entered. I wrote VBA code for this but getting an error dealing with my "The expression After Update you entered as the event property setting produced the following error: Method or data member not found." I'm not sure what I coded incorrectly Any ideas? The field names on the form are CSR_Name and CSRemail. On the CSR_Name field I have an Event Procedure to run this code After Update:
Thanks!
I was able to get this figured out. Thanks.
2 Replies
Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?
- mzeller1776Brass Contributor
I was able to get this figured out. Thanks.