Running an update query to a memo field

Question

This may be a simple one (whether it is possible or not).. I have two tables which are identical with a set of records. I need to find the best way that when one of the memo fields is modified, that the modifications get carried to the identical record on the corrisponding identical table. In many cases the field may have hundreds of words.. The only way that i know how to potentially do this is using an update query, but i am wondering if the test within is really large, will it break? Or is there another way? Thanks, A

Answer 1

Since you're working with Access 2010 you can use an After Update data macro to copy the changes back to the main table:

For more information see

Create a data macro