Results 1 to 10 of 10
  1. #1
    Join Date
    Jun 2004
    Posts
    11

    Unanswered: combo box / text box help!

    I have a form that has two comboboxes, cboTeamName and cboAgentName. I've managed to filter cboAgentName based off cboTeamName selection, so I guess my question is, how do I populate the textboxes with records for the cboAgentName selection?


    My Tables

    tblTeams
    (Not displayed on the form)
    TeamID
    TeamName

    tblAgents
    AgentID
    AgentName
    TeamID
    (These fields are displayed as textboxes on the form)
    nACDInts
    nOutInts
    nCustSat

    For example:

    On Team1 there is AgentBob, AgentSteve, and AgentMike
    On Team2 there is AgentJoe, AgentFred, and AgentTom

    If I select Team2 from cboTeamName, I will only be able to select AgentJoe, AgentFred, and AgentTom from cboAgentName. Now if I select AgentTom from cboAgentName, I want my textboxes (tblAgents.nACDInts, tblAgents.nOutInts, and tblAgents.nCustSat) to populate the records for AgentTom on my form.

  2. #2
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    SomeTextBox.Value=SomeCombo.Column(XXX,SomeCombo.L istIndex)
    Back to Access ... ADO is not the way to go for speed ...

  3. #3
    Join Date
    Jun 2004
    Posts
    11
    I'm sorry ... I am pretty new to the world of Access so I'm already lost in your answer. Would you be so kind to put that in newbie terms?

  4. #4
    Join Date
    Jun 2004
    Posts
    11
    Okay .. I've tried a few things, and still am as lost as ever. Any suggestions anyone?

  5. #5
    Join Date
    Apr 2004
    Location
    metro Detroit
    Posts
    634
    Is your form currently showing all records?

  6. #6
    Join Date
    Jun 2004
    Posts
    11
    it is just showing the first record in the database

  7. #7
    Join Date
    Apr 2004
    Location
    metro Detroit
    Posts
    634
    What is the record source of your form?

  8. #8
    Join Date
    Jun 2004
    Posts
    11
    it's pulling the records from tblAgents

  9. #9
    Join Date
    Dec 2003
    Location
    Dallas, TX
    Posts
    1,004

    Smile

    Quote Originally Posted by rogue
    What is the record source of your form?
    Could you zip and post a sample of your database for better help?
    That sometimes works wonders.

    Bud

  10. #10
    Join Date
    Jun 2004
    Posts
    11
    Here is the db zipped
    Attached Files Attached Files

Posting Permissions

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