MS Access Form Filter Example

MS Access VBA Form Filter Example

In a previous post I gave an example of a MS Access form filter. This revision is to demonstrate how to requery a form after the combobox changes, and not when a button is clicked. Here is the code: Private Sub cboDescription_AfterUpdate() Me.FilterOn = False m_Where = m_Where & ” AND Description = ‘” & […]

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

How To Make A MS Access Filter Form With Combobox Using VBA

Hi, I was working on a filter similar to this query, and I noticed someone may have some questions on how to do it. So this post is going to show you how to filter some date records with a combobox, actually 2 comboboxes. Here’s the jist of the question: ” I have a Microsoft […]

Continue Reading