subform query not showing records with Null values

  • Thread starter Thread starter Santiago Gomez
  • Start date Start date
S

Santiago Gomez

Hello

I have a simple search form, with a subform (in datasheet mode) whose
recordsource is a query. The query has all the search fields and under each
criteria it has:
Like "*" & form_frmName.txtBox1 & "*"
etc
The search works well, but it doesnt show any records where one of the
search fields is empty (null).

what can I do to show all records, even if other fields are null?

thanks
 
Try modifying your criteria to read:
Like "*" & form_frmName.txtBox1 & "*" Or Is Null
 
Back
Top