I have just watched the 222 class with update query. You had the update query change the DueDate if completed was false. This got me thinking that there must be a way to have a message box will pop up if I change the payment type to the words “Credit Card” on my customer Transaction subform within my main customer form. The message box will  remind me to change the customers payment from cash to credit card on the main customer form. Like a update query but with out running a query just having a message box pop up if the words “credit card’ is typed in the subtable payment section