VBA Check results of a Query and Display Message

[Littlemalky]

Hi, I am working on automating a few processes. I created a form with a series of buttons. One of the buttons I want to use "On Click" to run a find duplicates query that I have. However, I don't want the query to open up, I merely want a message box to pop-up telling me if a duplicate was found or not. How do I write code to check the contents of a query?

Thanks!

 

[Joe4]

You can use the DCOUNT function in VBA to count if there are any records being returned by your duplicate query (check to see if it the count is greater than zero).
See: MS Access: DCount Function

 

[Littlemalky]

That worked. Thank you.