Can someone please help me with this?
Two tables Work Orders & Service Orders, I can have many Service Orders to one Work Order. When a service order is entered the user has the option to close out the work order (Checkbox). If someone closed the Work Order and needed to add a forgotten or late submitted service order I want the user to prompted the work order is closed and for it not to run my query to close the work order. I have not done this in VB and looked a some code and it's just not clicking. Can someone help me.