I have no coding experience. I want to copy the contents from one field in table1 to a field in table2 if a totally different field in table2 is true.
I have created a form based on a query containing both of the two tables mentioned above. I am trying to attach the code to "After Update" for the totally different field mentioned above in table2.
Here is what I have tried and is obviously not working.
= Update [tblVenues].[VenueContactMailingAddress]
SET [tblVenues].[VenueContactMailingAddress] =
[tblContacts].[VenueContactPhysicalAddress]
WHERE ([tblVenues].[VenueContactMailingAddressSame] = 0)