Hi - I have a macro (mcrImportClaims) that is attached to the OnClick Event of a button that resides on a Form. This simple macro executes an append query (qryImportClaims) that reads records from a SQL table and appends them to my Access table. The macro runs a delete query first, then the Append query and displays a message. The reality is - not all the time are records imported so I would like to know if there's a way to differentiate the message based on record count? So if the record count > 0 display "Claims successfully imported." Else "Zero records imported." I have used If/Else logic in macros before and actually tried to create a 3rd query that checks my table and counts by the ID field but I can't refer to the query object in my macro. I get an error message. Any suggestions on how I can go about making this work so messages display according to the correct scenario?
Thank you,
Ann Marie
Thank you,
Ann Marie