Selection List -> Transfer to table & Filter

[bertusvanrooy]

My problem relates to a multi-selection that has to be made from either a ListBox or Table [Available Options] and the values then to be transferred to another table [Selected Options]. The ListBox with available options then has to be filtered to omit the values that has already been transferred to the [Selected Options] table.

I am working with a main form with 1 subform containing [Available Options] and another subform containing [Selected Options].

I have included an aimage to illustrate my problem.

Any ideas on how to approach this problem will be appreciated.

Thanks.

 

[Mile-O]

Have a look at the RowSource of the listboxes in this example - is this what you mean?

 

[bertusvanrooy]

Relationsships & Filtering

Thanks for your reply, you have definately put me on the right track. Let me tell you what I have done.

I used a LIST "lst_Available_Options" to display the items I need to select from. The list is filtered based on the value of a Combo Lookup called [Machine Code] from table "tbl_Machines_Selected". on the same form. I created an event that writes the [Option Code] and [MachineConfig_ID] values to a table called "tbl_Options_Selected". - Please see attached image of my relationships & form. I display the table "tbl_Options_Selected" in a subform next to "lst_Available_Options".

This works fine. The problem I have is that when I create a new record in "tbl_Machines_Selected" I want the "lst_Available_options" to again display all the options against [Machine Code].

Also I would like "lst_Available_Options" to show items that I delete from "tbl_Selected_options" as available for selection again.

I hope this makes sense, I think the images might make my make it more clear.

Thanks again for your help.

 

[bertusvanrooy]

Relationships

Here is the graphic for my relationships.

Thanks.