Search from form returns empty

[anishkgt]

Hi,

i was tweaking one of my forms, now the results show empty when i search ? how is that possible the query is the same tho.

 

[arnelgp]

is it possible for you to upload your db?

 

[anishkgt]

the file is a little big here is the dropbox link

 

[arnelgp]

what form and query will i work with?

 

[anishkgt]

The query is instock_search and the form is frmSearch

 

[arnelgp]

can you try this onehttps://www.dropbox.com/s/frmz78f5472c46v/Inventory_Local.zip?dl=0

 

[anishkgt]

Thanks arenel. That did it. what was the issue ?

 

[anishkgt]

now i need to consolidate the search results of both instock and delivered into one result. will try with the tips what you have ammended and see how it goes, else " i'll be back"

 

[anishkgt]

Hi Arnel,

just tried a new query with your example in the previous. can't get it to. i can understand the whole nz function but not clear here. Could you have a look at it here's the link.

 

[anishkgt]

Oh and the query is qrySearchConsolidated and the form is frmsearch.

 

[arnelgp]

what is not working?

 

[anishkgt]

Firstly the query you've amended is ok but the one query qryInstock_search when searched for 6C182607R as a serial number shows up which should not as its delivered (qrySearch)

Secondly the new query qrySearchConsolidated is not when checking with serial numbers and other criteria returns blank.

 

[anishkgt]

The whole point of the qrySearch and qryInStock is that once delivered (qryDeliveryOverview) the qrySearch should show the asset and qryInStock should not and if not delivered, it will not show up in QryDeliveryOverview and qrySearch but should show up in qryInStock. Hope am making things more clear