I have a form which has a field named txtPart_No. When the user has made an entry in this textbox I want a message box to appear IF certain criteria exists. First of all a query has to run that looks like the attachment. The query is named "qryScrapPercentForLastThr
Then IF the field "Scrap Percentage" from top to bottom in the query is descending in value, (in other words, if the first record was 20.1%, the middle one was 15.7%, and the last one was 8.9%), make the message box appear.
But the message box has to give the user the choice to either print a report (yet to be designed), or close the message box and proceed.
I don't know how to code the afterupdate event of the field txtPart_No