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.

 

[Pat Hartman]

Welcome aboard. In the future, please start a new thread for a new topic. You can refer to an old thread if you think there is something relevant in it.

Your code is out of context but it includes nothing about the date field. So, you need to add a second condition if you want to include only rows where this field is not null.

 

[isladogs]

Pat
It was a new thread

 

[Pat Hartman]

Was it? Or did someone move it later?