Hi!
I want to be able to filter a form based on a dropdown box, where one of the items can be null. (The field is of type short date).
the dropdown box is named "Fltr1".
The form is based on a query, and i have tried to express the filter in the query like this (sql syntax):
([Tablename].[Columnname]) Like "*" & [Forms]![frmMyForm]![Fltr1])
But this way, the records with this column being null are omitted...
I very much appreciate any help that leads me in the right direction
thanks
I want to be able to filter a form based on a dropdown box, where one of the items can be null. (The field is of type short date).
the dropdown box is named "Fltr1".
The form is based on a query, and i have tried to express the filter in the query like this (sql syntax):
([Tablename].[Columnname]) Like "*" & [Forms]![frmMyForm]![Fltr1])
But this way, the records with this column being null are omitted...
I very much appreciate any help that leads me in the right direction
thanks