Access: Filter combo box - how it works

You can easily filter a combo box in Access. In this practical tip, we will show you exactly how that works.

Filter combo box in Access - how it works

1. First start Access and open your database.
2. First, create a new macro in Access.
3. Insert the command "Private Sub Kombi_AfterUpdate () Me.Filter =" your combo box "& Me! Kombi &" '"Me.FilterOn = True end sub".
4. Exchange "your combo box" with the name of your respective combo box.
5. Then run the macro to apply the filter.

In the next practical tip, we will show you how you can create a calendar in Access.