Results 1 to 2 of 2
  1. #1
    Andyjones is offline Advanced Beginner
    Windows Vista Access 2010 32bit
    Join Date
    Sep 2011
    Posts
    76

    Auto Populate Txt Field

    I have a form that I need help with the problem is this



    I have two team called langley B but each team plays in a different division.

    So in the form when I select either langey B team I want the div lable to auto populate to show waht division the team is in. could someone have a look at this and sort this out for me.

    Attached File(s) Langley_B_Player_Stats_and_Averages.zip ( 619.82K

  2. #2
    aytee111 is offline Competent At Times
    Windows 7 32bit Access 2010 32bit
    Join Date
    Nov 2011
    Location
    Nomad
    Posts
    3,936
    Change the team combo box to include the division name. Then in the AfterUpdate event of the team, add this code:

    Me![Division Type]=Me!Combo41.Column(2)

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

Similar Threads

  1. Replies: 3
    Last Post: 02-02-2012, 09:48 AM
  2. Replies: 3
    Last Post: 10-03-2011, 02:33 PM
  3. Auto populate a field (without a form)
    By DonL in forum Access
    Replies: 1
    Last Post: 06-21-2011, 03:19 AM
  4. Replies: 16
    Last Post: 11-18-2010, 11:08 AM
  5. auto populate combo field?
    By myboii in forum Access
    Replies: 8
    Last Post: 07-09-2010, 05:46 AM

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 - Senior Forums