Highlight previously selected fields in listbox

[spudracer]

I've got a form where I need to be able to display all records, but highlight records already added to a specific record.

I know this is simple (or at least I think it is), I just can't wrap my head around it.

 

[vbaInet]

I know this is simple (or at least I think it is), I just can't wrap my head

Let's see a screenshot of the layout of your form with arrows indicating what goes where.

Does each related record have a unique ID?

 

[spudracer]

There is really nothing to show. Just a simple listbox (w/one column). Here is the datbase I'm working with.

Each trip has a unique ID, but I want the form to at least tell the user who's already been added to that trip ID.

 

[vbaInet]

There is really nothing to show. Just a simple listbox (w/one column). Here is the datbase I'm working with.

I'm not at liberty to check it

How about a second listbox or subform (which is read-only) that lists all those already added.

 

[spudracer]

How about a second listbox or subform (which is read-only) that lists all those already added.

I suppose that would work. How would I go about doing that? This is probably one of those things that's easy to do, but my brain has been fried by this database, and even the simplest of tasks (walking and chewing bubblegum at the same time, for example) are almost impossible.

 

[vbaInet]

It would be a matter of:

1. duplicating the current listbox
2. right-click the line that joins the parent table to the child table, click Join Properties
3. Select the option that reads something like, "Include ALL records from the 'Parent table' and only those records ..."
4. Ok to that and finally put Not Is Null under the ID field from the child table.

The reverse of step 4 will list those not added.