I have this code set to a button on a split form. It filters out all the blank records for the "Status" column.
Private Sub cmdFilterPendingStatus_Click()
Me.Filter = "[Status]"
Me.FilterOn = True
Me.Requery
Me.txtFilterNamePlate.SetFocus
End Sub
I would like to do the exact opposite and filter out everything except for the blank records in the "Status" column.
How can I change the code to do this? I guess I should also mention that the "Status" field is a long text/memo box but I can easily change this to short text if I really have to. I realize that short text can do the blank filtering within the split form itself by clicking on that tiny arrow in the column header but I am trying to make it really user friendly where the user can just click a button to do this. The long text box has some options to filter but not for blank fields in a record which makes me think that this may not be possible to do if the Status field remains a long text box. Some examples for the filtering options that are available in the split form for a long text box are: Begins with, contains, ends with, etc... however, when I type "" to try and filter out everything except the records that have null in the Status field, it says that "" is not valid. Anyway, sorry for making this so long. I think you guys get the picture.
What can I do to get the results I need?