I'm not sure what is the best option and least code. I am selecting records and displaying them in a listbox. I want to link the records back to a table. If the record is on the table I do not want it to be able to be selected. I want the records that have no link to the table to be marked already selected. Listbox allows the first 2 options.. What listbox does not allow is if the record is on the table I link to I want to change the forecolor. Listbox only allows color change for all items in the listbox. I also want the records that I find on the other table to not be selected. Either locked or not enabled. Listbox does not allow that. Unfortunately this is the display and function needed.
My question is what is the best way to code this? By best I mean easiest and least code! Listview (activex), a grid, datasheet or some other option?