Filter of list field (1 Viewer)

[mmitova]

Hello, I have a microsoft access database where materials are entered and entered, and one part of the forms to write them needs to be distributed to more than one product. Products are selected from a list box that is set to contain more than one value. The field has four columns: ID, Name, Entry Date and Location; When it comes to products there can be thousands and therefore this field needs to be filtered somehow. It is most convenient through the location. Can someone give me more information on how to do it.

 

[Pat Hartman]

You can add another combo that lists all locations and use that to filter the product combo,