Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2014
    Posts
    1

    Unanswered: list box updating in msaccess

    Hi
    I am a newie to MSAccess and have a question please
    I have a database with Clubs, players, scores etc.

    I have set up a form with a listbox with the Clubs
    How do I get the form to populate the Players when I select the Club so that I can then enter the scores etc?

    Thankyou.....Julie

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    That sort of requirement is usually done using cascading list boxes. Theres plenty of examples both here and on the internet.
    Listbox 1 contains teams
    Listbox 2 contains players.
    When you add a new record set listbox2 to no value / null
    When the user selects a value in listbox1 then populate listbox 2 with players for that team
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

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