Remove listbox items from matching subform table.

[GrtSlvrDrgn]

Is it possible to remove items listed in a listbox from duplicate values in a subform table field?


Both the listbox and subform table have matching fields and I want to remove matching records from being shown in the listbox.
The listbox is populated by a table different than the subform table, but both have the same fields.

Any help is appreciated.

Thanks.

[pbaldy]

Does the unmatched query wizard produce the desired result? If so, it could be the row source of the listbox.

[GrtSlvrDrgn]

It's kind of more complicated that that. This is a training database and I have a form that shows an employee's record. On that form I have a table in a subform [Events] that is the employee's training record [Training Records] table. The form also has a listbox that shows all training available from the [Training] table. What I have been struggling to do is eliminate the listbox training items that are already attached to that employee's record. The training and training record tables have a key field [ID]. Thanks for the suggestion.

[pbaldy]

Should still work, though you probably have to query the training the person has done for one side of it. Can you attach the db here?

[GrtSlvrDrgn]

I am not that familiar with that particular query and I could not get it to work. I think it only looks for the ID in the entire table regardless of which Employee is assigned to. Attached is the DB and the employee records form is where my complicated issue exists.

On the form you will notice the subform table showing all training completed by the employee and to the right of it a listbox showing all training that is in the DB, I want that listbox to show only training that the employee hasn't done (as in not shown on the subform table)

Thanks for the help.

[aytee111]

Create an unmatched query by using the Query Wizard, it will ask you which tables and which fields you want to find. use this query for your list box as Paul has been saying, showing all training records that are unmatched on the employee's training table.