I have built an audit database using MS Access where users enter various items of data & a record is saved for review later.
At the offset, the auditor enters the reference for the file being audited, and presses a "Check History" button. This runs a query against the audit table to check if the file has been audited previously. If it has, then a pop up form is displayed showing the reference & some other data. If no record is found, the same form pops up, but showing its default value of "no matches."
What I would like to do is replace the pop up form with a message box, containing the same information.
Whilst I have built message boxes before, I have never done so where it is driven by a query.
Please can anybody offer me any pointers?
Thanks as always.
At the offset, the auditor enters the reference for the file being audited, and presses a "Check History" button. This runs a query against the audit table to check if the file has been audited previously. If it has, then a pop up form is displayed showing the reference & some other data. If no record is found, the same form pops up, but showing its default value of "no matches."
What I would like to do is replace the pop up form with a message box, containing the same information.
Whilst I have built message boxes before, I have never done so where it is driven by a query.
Please can anybody offer me any pointers?
Thanks as always.