I have a macro that runs a query to find Max date of a table, then (I think) I want to use Dcount to see if that date exists on another table. If it does exist, I want the macro to stop processing and display an error message (i.e. "Error with file"). If it doesn't exist, let the macro continue processing. Can someone give me step by step instructions as I'm fairly new to Access and completely unfamiliar with VBA.
Thank you.
Thank you.