Results 1 to 3 of 3
  1. #1
    jkeysch
    Guest

    Updating data in table that uses lookup field (Access 97)

    I have a quick question. I have a Information table that contains all of the names of scholarhips that we offer. We then have a awarded table which uses a lookup field so that only one of the corresponding scholarhips can be chosen from the Info table. However, when an update is made to a scholarhip name in the Info table, it doesn't update it in the Awarded table. Is there a way to tell Access 97 to do this? Thanks

  2. #2
    New Lounger
    Join Date
    Nov 2001
    Location
    Indiana
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Updating data in table that uses lookup field (Access 97)

    Do you have the Awarded table open while you are changing the entry in the Info table? I think you need to close the Awarded table (or else Requery it in code) to see the change. Hope this helps.

    Ken Granger
    The Original Kenny G

  3. #3
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Newbury, Berkshire, England
    Posts
    712
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Updating data in table that uses lookup field (Access 97)

    I would make a backup db first and then start a new db and copy your tables, scholarship (info) and awards into that. Next make sure that you have an auto number field set to unique in your scholarship table, if you don

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •