I have a form in Access that has 1 text box and 1 button. It acts as a search form for users and when the button is clicked, it opens the "qrySearchName" query. The query then searches the "Name" field in the "tblCaseloads" table for results and returns the results in datasheet view. Only 0 or 1 records can be returned by the query.
Instead of displaying the results in datasheet view, I want to display a MsgBox that states either: "Record was not found" or "Record was found".
I believe this needs to be done through code in VBA, but I have not used VBA before. I have looked through VBA on my own and I know ASP so I have a basic understanding, but just don't have time to learn this right now. I need someone to write this little code for me and tell me how to plug it in.
1) Complete and fully-functional VBA code and instructions how to implement it.