Display message in detail of form when no records present

[Gerdagan]

Hi all,

I have a form that is sourced from a query. Sometimes there may be no records to display. Is there any way of having a label in the detail of the form that states "No records available" for example.

Thanks.
Ged.

 

[GohDiamond]

Create a Textbox using a DCOUNT based on a key field, such as a date, and if the response is 0 then have the [Textbox].visible = true display the message you want, but if the response is >0 then that [Textbox].visible = false

Put it on the footer of the form if it's a subform

Cheers!
Goh

 

[Gerdagan]

Create a Textbox using a DCOUNT based on a key field, such as a date, and if the response is 0 then have the [Textbox].visible = true display the message you want, but if the response is >0 then that [Textbox].visible = false

Put it on the footer of the form if it's a subform

Cheers!
Goh

Thanks for that Goh. How would a write the coding for that? I'm having some trouble figuring it out.