My form has two form filters. However, only the Region seems to be working. (This is just the start of database I am trying to create. It will have a lot more in the future.)
The vendor form filter doesn't seem to do anything at all except refresh the screen. Could someone let me know how to fix that.
Here is the VBA code I have so far:
Option Compare Database
Private Sub cboFilterRegion_AfterUpdate()
Me.Filter = "RegID = " & Me.cboFilterRegion
Me.FilterOn = True
Me.Requery
End Sub
Private Sub cboFilterVendor_AfterUpdate()
Me.Filter = "VenID = " & Me.cboFilterVendor
Me.Filter = True
Me.Requery
End Sub
Private Sub cmdClearFilter_Click()
Me.FilterOn = False
Me![cboFilterRegion] = Null
Me.Requery
End Sub
Private Sub cmdClearVendor_Click()
Me.FilterOn = False
Me![cboFilterVendor] = Null
Me.Requery
End Sub