Count results from query with no results

[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?

 

[Dale Fye]

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

Dale

 

[Ryan Tisserand]

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

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.

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?