Results 1 to 2 of 2
  1. #1
    tagteam is offline Competent Performer
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2013
    Posts
    486

    Can Data Macro update another table when one field is updated

    I have been looking at Data macros and I am not sure if it will work for me.

    I have the same field in two separate tables. I know that is bad database design but these are fields actually in two separate databases and I am using links to have them end up in the same table.

    When the field is updated in one table I would like it to be automatically updated in the other table. I was hoping that a Data Macro would work but it doesn't appear to let me assign it to a particular field.

    If that won't work, I am looking for any way I can to auto update that field. I had a thought that maybe I could bring it up on another form and update it and then use and after update on the form.

    Any ideas would be appreciated.


    Thanks

  2. #2
    ranman256's Avatar
    ranman256 is online now VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    In a form, set the textbox for the field's AFTERUPDATE event to run a macro/vb to run an update query to update the same field in table2

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 9
    Last Post: 07-11-2017, 07:51 AM
  2. Replies: 9
    Last Post: 05-23-2017, 11:56 AM
  3. Replies: 4
    Last Post: 10-14-2015, 02:33 AM
  4. Replies: 2
    Last Post: 08-27-2015, 07:38 AM
  5. Replies: 4
    Last Post: 01-10-2014, 01:20 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums