How to filter in a list?

Question

Microsoft Access

There is a list with organizations


. There is a task to add filtering of organizations by part of the name. I enter orion at the top and I should show all the matches, how can this be done?

Answer 1

You can use a drop-down list with the source of the lines of the enterprises you need. The list can be taken from a table or specified manually. Based on it, you can apply a filter. For the filter, you can use both data from the list, or enter it manually, and as you type, options will be offered