Forum Discussion

mzeller1776's avatar
mzeller1776
Brass Contributor
May 07, 2025
Solved

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!

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?

    • mzeller1776's avatar
      mzeller1776
      Brass Contributor

      I was able to get this figured out. Thanks.

Resources