Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Jul 2008
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Relate/link fields

    This is probably simple, but I haven't figured it out yet.

    I have two tables - Originators (containing ID#, Originator, Organization, and Phone#) and Trouble Reports (containing Autonumber, Originator, Organization, Phone#, Trouble Description, Solution).

    I've got the Originator field in the Trouble table to read the Originator field in the Originators table. What I now want to do is if "Joe" is selected as the Originator, then Joe's Organization and Phone# would automatically fill in. I just can't figure out how to do this. Can anyone point me in the right direction? Thanks.

  2. #2
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Tennessee
    Posts
    194
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Relate/link fields

    in your query for the form have the Originator
    control set for the criteria for the query
    then in the afterupdate event of the Originator control
    place this code
    me!requery
    everything should automatically fill in
    HTH
    JerryC

Posting Permissions

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