Problem utilizing filter code when there is a null or blank value

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

This is the code I utilize when a user chooses a value within a combo box:

Me.Filter = "Location = '" + Me![Location1] + "'"
Me.FilterOn = True

There are sometime null or blank values as a choice and when chosen the code
fails. Is there a way to modify the code to not fail and actually show the
records that have a null or blank value?

Thanks in advance,
John
 
Back
Top