If result of query is nill

[puthenveetil]

Hi all,

Is there any way to show a message if a query can't find any record with a criteria????


Thanks in advance

Thanks

 

[ColinEssex]

I use the OnNoData property of the report.

Col

 

[The_Doc_Man]

If it is not a report, but is instead on a form, you will get a visual indication that nothing came back 'cause your form will be blank.

If this is in VBA then there is such a thing as testing the recordset to see if it is simultaneously at EOF and BOF (both properties set to Yes at the same time.) That's a dead giveaway of no records.

 

[daveUK]

Place the following code on the forms On_Open event

If Me.RecordsetClone.RecordCount = 0 Then
    MsgBox "There are no items to display", vbInformation
    DoCmd.Close acForm, "Name of Form"
End If

 

[puthenveetil]

Hi Dave,

That worked....Thanks