Reply to thread

Message: [QUOTE="ChrisL7, post: 1996392"] I am trying to use a macro in Access to highlight expired date entries in the database. I can do this by calling up a report in a macro and notifying the user, but I don't want the report to show if there is no detail. Currently, I can't get the macro to work without calling up the report on screen and, if there are no expired dates, I get a 'data type mismatch' error message. Ideally, I would like the user to be unaware of the running macro unless there are expired dates which need correcting, in which case a visible report would be satisfactory. Can anyone suggest a way of doing this? [/QUOTE]