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 any one of the records in the query has a "Scrap Percentage" that is 10.0% or greater, 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