wrong search results

[quest]

Hi
I have form that search records with subform. it works perfect if there is not empty date field. if there is empty date field each search return the empty date field too. how to exclude empty date field.
thanks

 

[GPGeorge]

Hi
I have form that search records with subform. it works perfect if there is not empty date field. if there is empty date field each search return the empty date field too. how to exclude empty date field.
thanks

How does the search work? Perhaps including the details of how that search is implemented will provide enough context for someone to suggest the appropriate modification to it.

 

[theDBguy]

Hi. Welcome to AWF!

You should be able to adjust your search criteria to include or exclude empty date fields.

 

[The_Doc_Man]

To answer that question we would need to see the code (SQL and/or supporting VBA, whatever you are using for this) to perform the search.

 

[quest]

i have main form which on load open subform with all records. there are comboboxes for searching. can be searched with single or multiple comboboxes. in this case search should show only last two records without first one. date field is empty next to red field (conditional formating).
for searching I use simple macro
SearchForRecord"><Argument Name="WhereCondition">="[Основен број] = " &amp; Str(Nz([Screen].[ActiveControl],0)). this is for the combobox used in the case with the picture.

 

[isladogs]

Pat
It was a new thread