开发者

Handling no results for docmd.applyfilter

I have an Access app where I use search functionality. I have a TextBox and a Search Button on the form, and it does a wildcard search of whatever the user enters in the TextBox, and displays the records in other controls (Text and Combo Boxes).

To achieve this, I am using the DoCmd.ApplyFilter method and I wanted to know if there is a way that I can handle the 'no results' scenario? What it does currently is shows all the display controls as empty, and the ID field says (AutoNumber) as if I was开发者_运维问答 adding a new record.

If it is not possible to handle no results with DoCmd.ApplyFilter, then is there another way to search the records and handle the 'no results' scenario as well?


You can check the recordsetclone to see if there are any records and remove the filter if there are not.

DoCmd.ApplyFilter , "id=5"
If Me.RecordsetClone.RecordCount = 0 Then
    MsgBox "No records"
End If
0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜