Highlighting Items in List Box from Table Data

[swalsh84]

Apologies if this already was posted. I have a form that inputs data about a project. There are a total of 3 list boxes that are on this form. When you press the save project button, a go-between table saves a record of the projectID and the dependencyID. These are multiselect boxes so it is possible to have multiple dependencies on the same project

 
project1, dependency1
project1, dependency2

What I would like to do is on form load the list box is highlighted with this information. I have about 50 some odd projects and everytime the form loads the data is cleared. I have already created a way to delete all records if the information changes, but I would like to be able to see what I have already done. I just need to get the listbox.itemsselected to talk to the data in the table.

Does this make sense? Any thoughts?

Thanks in advance!

[llkhoutx]

Checkout "conditional formatting." Individual rows in a listbox cannot be highlighted, only selected or not selected.

Use VBA code to determine which rows are selected and then code their related table.

[swalsh84]

That's exactly what I want to do. Show which items are selected and not selected. The trouble I am having is that I cannot get the table to talk to the list box. I know which items I want to see selected, I just cannot figure out the syntax for the list box to reflect that.

Thanks for the starting point!