Hi all
I have a subform which is used to return search results from criteria entered on the main form. I have used this same setup many times without a problem.
On my subform footer, there are calculated controls used to display number of results and average value. No problem there.
It all works fime if the search produces valid results.
Usually, when the search returns no results, the calculated controls show 0, which is what I expect and want. However, on this particular form, if no results are returned, the fields completely vanish from the detail section of the subform and the calculated controls remain blank.
Can anyone let me know 1: why this is happening and 2: how to stop it happening. My desires scenario when the search returns no records is for the blank fields to show in the results subform and for the calculated controls to show '0'.
using Nz in the calcualations makes no difference.
Any help is, as always, much appreciated.
I have a subform which is used to return search results from criteria entered on the main form. I have used this same setup many times without a problem.
On my subform footer, there are calculated controls used to display number of results and average value. No problem there.
It all works fime if the search produces valid results.
Usually, when the search returns no results, the calculated controls show 0, which is what I expect and want. However, on this particular form, if no results are returned, the fields completely vanish from the detail section of the subform and the calculated controls remain blank.
Can anyone let me know 1: why this is happening and 2: how to stop it happening. My desires scenario when the search returns no records is for the blank fields to show in the results subform and for the calculated controls to show '0'.
using Nz in the calcualations makes no difference.
Any help is, as always, much appreciated.
