Form Filter

How To Open A Form To A Specific Record In Access 2016 VBA

In this post I am going to give you a basic example of how to open your Access form to a specific record. This works in all versions of Access, but we are using Access 2016 in this example. First create “parent and child” forms. In our case, it’s frmCustomers and frmOrders. Here’s “frmCustomers” Here’s […]

Continue Reading

VBA MS Access Form Filter Example

This post is going to show you a ms access form filter sample. The database I created only has one table called “Categories”. We are going to have a form called “frmCategory”. The form is going to be a “Split Form”, because that seems to be quicker than the “main form / sub form” setup. […]

Continue Reading

MS Access FilterOn Error (Solution)

This may help give you a clue to why your Me.FilterOn is not working properly. My form was doing some filters, but when it came to filtering the date, it wasn’t operating correctly. Here is my filtering code: If Len(FilterString) > 0 Then Me.Filter = FilterString Me.filterOn = True End If I noticed that if […]

Continue Reading