Unanswered: combo box selection populates a listbox
I have 2 tables:
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.
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