Through help from the forum, I created a command button to "Filter By Form" which basically clears the form in order to select criteria into the empty fields.
Private Sub <Name of your button>_Click()
DoCmd.RunCommand acCmdFilterByForm
DoCmd.RunCommand acCmdClearGrid
End Sub
....However, another command button I created to "Apply Filter" becomes unavailable after selecting the criteria. This 2nd button was created with help from the wizard. Do I need to create an event procedure by using the code builder instead of using the wizard in this situation? Furthermore, what is the vb code to apply the filter? Any info is much appreciated...thanks in advance!!
Private Sub <Name of your button>_Click()
DoCmd.RunCommand acCmdFilterByForm
DoCmd.RunCommand acCmdClearGrid
End Sub
....However, another command button I created to "Apply Filter" becomes unavailable after selecting the criteria. This 2nd button was created with help from the wizard. Do I need to create an event procedure by using the code builder instead of using the wizard in this situation? Furthermore, what is the vb code to apply the filter? Any info is much appreciated...thanks in advance!!
