Multivalue listbox filter

[ahmad_3011]

I have a form called Clients that contains two multivalue listbox I can chose from the city list more than one city I need to show the districts on the other city that matches with the selected cities

[ranman256]

This is not a good way. It requires a lot of code.
INSTEAD,
how about a single pick list in a listbox. User dbl-clicks from the list, which runs an append query, and puts this option in a 'pick list' table.

Items to pick FROM are in a source table,
items the user picks are put in the TARGET tPicked table
The query joins the tPicked table to the Data table.

NO CODING, just a few queries.
1 append query to add the user's pick
1 del query to erase only 1 selected item in the list
1 del query to erase all items in the list

[ahmad_3011]

ranman256

thank you for the idea, kindly do this to the attached file

[ranman256]

your tables are not designed correctly using normalization.
you should have a sub table:

clientID, city