I have a form that tracks parts we have on order in our shop. The PartNumber field has an On Lost Focus event. That code uses the part number entered and gets it's discription from the Inventory table.
If the discription entered by the use does not match the discription in the inventory table then the user gets a message box asking if he/she wants to replace the existing discription with th eone from the inventory table. This works fine.
The problem is I only want this check to take plase while the user is staying in the current record. If the form is closing or is going from one record to the next, I want this check by-passed.