This post is an answer to someone else who wanted to create a table and field names based on form inputs. So I simplified a past post: https://vbahowto.com/how-to-create-a-table-in-access-using-sql-and-vba/ Here are the form inputs: …and when you click the button, the following code runs: Private Sub btnCreateTable_Click() CreateNewTable MsgBox “Table Created. (Press F5 on your keyboard […]

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 […]