Search results

i thought that was the issue but that was set to NO already.

Hi, I have a data entry form for which one of the field needs to be ignored when entering data but when doing so the error returns saying " You must enter a value <some table>" is there anyway to ignore this field when needed ?

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

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.

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

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.

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" :)

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

The query is instock_search and the form is frmSearch

the file is a little big here is the dropbox link

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.

All these work when these are are added into the criteria as "4552015" or others. So frustrating:banghead:

Some results are based on different tables, for example AgencyName is not available in tblInventoryDetail as its not delivered and it shows up in tblDelivery. So the result show blank for AgencyName if the query searched with SerialNumber. The serial number is always there in tblInventoryDetail...

I guess got the join all wrong, how does this look Attached here is the screenshot of the query. The idea here with the query is to display the result of a search criteria to show if the particular record is delivered or in stock.

The SQL view of the query is as below

Anybody :(

ok ! now how can i verify that ? sorry not so familiar with VBA, i mostly work with macro.

Hi, i've got a query that should also show empty records also. Tried using Or is null but that is not helping. The query has several tables also, is subquery an option here ? not sure how to do that either :( but is there another way to get the result. thanks

Thanks figured it out.

Hi All, I was trying lock a text box based on the value of two cmb box value if txtqty=txtstk then setproperty of txtserial = FALSE Else Setproperty of txtserial = TRUE here when run the code skips...