Results 1 to 3 of 3
  1. #1
    warrigal is offline Novice
    Windows XP Access 2002
    Join Date
    Mar 2011
    Location
    Qld, Australia
    Posts
    5

    Linking forms

    Hi guys

    I have 2 separate forms that share a couple of fields from the same table. When I change the field on one table, it won't automatically change that same field in the other table. Is there a way to fix this?

    Cheers

  2. #2
    ajetrumpet is offline VIP
    Windows Vista Access 2007
    Join Date
    Mar 2010
    Location
    N/A
    Posts
    2,694
    Quote Originally Posted by warrigal View Post
    Hi guys

    When I change the field on one table, it won't automatically change that same field in the other table.
    first, what do you have two forms that share the same field on one single table?? that suggests a difficult-to-handle design.

    secondly, what exactly do you mean by the above quote?? CHANGE the field??

  3. #3
    warrigal is offline Novice
    Windows XP Access 2002
    Join Date
    Mar 2011
    Location
    Qld, Australia
    Posts
    5

    Thumbs up All sorted!

    I appreciate the response but I have just found out the issue. I have some "do you want to save" code plugged into each form for if something is changed. If, after changing the contents of the field, you click to move to the next record (to prompt the save button to come up), you can then save it and then it does transfer it to the other form as well. I probably haven't explained it any better but at least it works now!

    Thanks again.

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

Similar Threads

  1. Linking forms (I think!!!)
    By Sleepymum in forum Forms
    Replies: 5
    Last Post: 02-21-2011, 07:28 AM
  2. Linking Forms
    By glasgowlad1999 in forum Forms
    Replies: 1
    Last Post: 02-02-2011, 09:35 AM
  3. Linking two forms together
    By Lxmanager in forum Access
    Replies: 8
    Last Post: 09-27-2010, 05:10 PM
  4. Linking Forms
    By dalton in forum Forms
    Replies: 1
    Last Post: 05-30-2010, 11:23 PM
  5. Linking tables and forms
    By vgatell in forum Access
    Replies: 0
    Last Post: 02-10-2007, 01:37 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