Check Record Status if Changed Before Navigating To Next Record: Prompt User to Save
MS Access: Have Form with combo box for record lookup. Want to prompt the user if record status changed before navigating to next record. How do I check the status of the record before user navigates to another record. I have a save button, but this is bypassed when then they navigate with the combo box to another record.