Selecting Blank Records as a option

  • Thread starter Thread starter Lou
  • Start date Start date
L

Lou

I have a query that is the Row Source for a combo box
that is used to filter a form by date field. Is it
possible to have the query pull only the blank records as
an option? So, the user can see only the records that
have not been resolved yet? If not what would be the best
way to do this?
Thanks in advnace..
 
Do you mean the DateField is Null?

If you do, set the criteria

WHERE DateField Is Null

in the Query being used as the RowSource for the ComboBox.

HTH
Van T. Dinh
MVP (Access)
 
Back
Top