1

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

Erik A
  • 31,639
  • 12
  • 42
  • 67
Marchese Il Chihuahua
  • 1,099
  • 4
  • 31
  • 59
  • 1
    Is the update within a form? Why do you have two identical memo fields? – Fionnuala Feb 19 '14 at 22:02
  • it should be within the form.. They are identical because basically one table i use as a working table and it is compiled form a bunch of underlying tables which feed to it. This table was created specifically for a report but now i want the user to be able to change the content of one memo field within the report and i would like thta this change gets reflected in the underlying table – Marchese Il Chihuahua Feb 19 '14 at 22:07
  • 1
    Odd. Consider the AfterUpdate event with a suitable ID. – Fionnuala Feb 19 '14 at 22:09
  • Yes, but do you see any disadvantage to using an update query (in SQL), linking the two records and updating the memo field?? – Marchese Il Chihuahua Feb 19 '14 at 22:12
  • Sorry, you have to excuse my ignorance.. Are you refering to using something along the lines of DAO or ADOX? – Marchese Il Chihuahua Feb 19 '14 at 22:17
  • 1
    DAO more or less every time with MS Access http://stackoverflow.com/questions/2338978/what-is-a-recordset-in-vba-what-purpose-does-it-serve/2339004#2339004 – Fionnuala Feb 19 '14 at 22:25

1 Answers1

2

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

AfterUpdate.png

For more information see

Create a data macro

Gord Thompson
  • 116,920
  • 32
  • 215
  • 418