Apparently my form is Dirty as soon as I open it. If I make no changes and close it my vba message to ask if I want to save it comes up. How do I determine why that's so? The form has two subForms and a subReport.
Thanks
Apparently my form is Dirty as soon as I open it. If I make no changes and close it my vba message to ask if I want to save it comes up. How do I determine why that's so? The form has two subForms and a subReport.
Thanks
Go through every section of event code that exists.
Put a breakpoint on the first line of executable code and use F8 from then on.
If no code in Open event add a MSGBOX and break on that.
Please use # icon on toolbar when posting code snippets.
Cross Posting: https://www.excelguru.ca/content.php?184
Debugging Access: https://www.youtube.com/results?sear...bug+access+vba
Thanks so much. I had previously copied and pasted a form. The original form had code that was causing the issue.
For future reference, you might clue in to the fact that you'd need to examine the code by looking at the form when it opens. If you chose to leave record selectors visible and saw that there was a pencil icon in one of them, it means something has started an edit in a record, or has started a new record. That can be as simple as setting a field value in code when a form loads.
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.