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

    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) ( 619.82K

  2. #2
    aytee111 is offline Competent At Times
    Windows 7 32bit Access 2010 32bit
    Join Date
    Nov 2011
    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