Count results from query with no results

  • Thread starter Thread starter Ryan Tisserand
  • Start date Start date
R

Ryan Tisserand

I have continous form with an unbound text box [keyword] and a button
[search]. There is also an unbound textbox [numberofresults] that counts the
number of records returned. If the search produces no results, the
[numberofresults] needs to read 0, instead it is just blank. What is the
proper way to show zero results as 0 and not blank?
 
It depends on how you are doing your search? Do you have a function? Are
you just filtering the recordset?

Dale
 
The unbound [keyword] is passed in as a query perameter and the search button
does a Me.Requery. Here is the query perameter.
Like "*" & NZ([Forms]![ICD9 Codes Lookup]![Keyword],"23AZZKLAV::::") & "*"

Dale Fye said:
It depends on how you are doing your search? Do you have a function? Are
you just filtering the recordset?

Dale
--

email address is invalid
Please reply to newsgroup only.



Ryan Tisserand said:
I have continous form with an unbound text box [keyword] and a button
[search]. There is also an unbound textbox [numberofresults] that counts the
number of records returned. If the search produces no results, the
[numberofresults] needs to read 0, instead it is just blank. What is the
proper way to show zero results as 0 and not blank?
Click to expand...
Click to expand...
 
Back
Top