Yeah, exactly. Except why when I open the form, in the listbox there is an occurence of each jobID 4 times and each color displayed? Other than that, it's what I was looking for. Thank you.
Alright.. All of my issues with this project are fixed (so far), except one. Why when I click on any record in the ListBox, it brings up an error? Well, I guess I know why.. But the problem I have is.. When I click on a record, I'd like the information that is in the ListBox populate into it's corresponding ComboBox. (Like Search02.zip from http://access-programmers.co.uk/forums/showthread.php?t=65331) Anyone's help would be appreciated.