Results 1 to 7 of 7
  1. #1
    Join Date
    Feb 2010
    Posts
    20

    Unanswered: combo box selection populates a listbox

    I have 2 tables:
    job table
    rental table

    on my form i have a combo box and a list box. the combo box will pull up all of the jobs and i want the list box to list all of the rentals for that particular job. once the listbox is populated i will then make a selection to pull up the record for that rental.

    i can list the jobs in the combo box and show all of the rentals for all jobs but i cant filter the list box to those rentals for the job selected.

  2. #2
    Join Date
    May 2005
    Location
    Nevada, USA
    Posts
    2,888
    Provided Answers: 6
    A couple of methods here:

    Cascading Combos
    Paul

  3. #3
    Join Date
    Feb 2010
    Posts
    20
    I'm getting close. i used the first example not the sql string.
    when i select a job from the combo box the list box populates with the job number, and it lists the job number as many times as there are rentals for that job. i just need to make the list box show the rental description instead of the job number

  4. #4
    Join Date
    May 2005
    Location
    Nevada, USA
    Posts
    2,888
    Provided Answers: 6
    That's determined by the row source (table or query) and column width properties of the list box.
    Paul

  5. #5
    Join Date
    Feb 2010
    Posts
    20
    think i just figured it out. in the row source i had the description before the ID and i switched them around and it works

    thanks

  6. #6
    Join Date
    Feb 2010
    Posts
    20
    now when i select a rental from the listbox the record wont come up

  7. #7
    Join Date
    May 2005
    Location
    Nevada, USA
    Posts
    2,888
    Provided Answers: 6
    Make sure the criteria is still on the appropriate field.
    Paul

Posting Permissions

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