I have a VB app that I am developing which is essentially a Human interface to an Access database. I end up searching through various tables in the database using Data Object controls. I'll search for something using a command like this:
datExample.Recordset.Seek "=", searchstr$
If there is nothing found in this seek I get a dialog box that I can't control whose title bar reads: "Microsoft Visual Basic" and the message in the dialog box says: "No Current Record". There is a red dot with a white X in it and two buttons, OK and Help.
I know this is the correct response, I looked for something that wasn't there and it is telling me that.
This is my question:
Is there a way to make that dialog box go away, or is there a way to control it like you can other message boxes? If I create a message box that appears if the recordset.nomatch property is True then I can make it say whatever I want but I still get the "No Current Record" dialog box before it. This makes the message box I can control seem redundant. It also adds clicks for my Operators. Any thoughts
Thanks in advance for your help