Hi, is there VB Code to suppress No Data to Fetch and keep the prompt? I have looked at all the replies to this issue and cannot find a solution. While the following code suppress No Data to Fetch, it also suppress the prompts.
Private Sub Document_BeforeRefresh(Cancel As Boolean)
Application.Interactive = False
End Sub
Private Sub Document_AfterRefresh()
Application.Interactive = True
End Sub
I need to suppress No Data To Fetch, but keep the Prompt. Thank you in advance.
Thank you for the suggestion. I have read the FAQ already, and it does not provide me the solution I am looking for. The VB script does not work because it makes the prompt disappear. The Union Query does not work because it would mean i need to recreate all the queries and try to come up with one piece of dummy data. The adding a table method does not work either because i am not a designer. Thank you.