I have myForm with mySubform. I have a button on myForm that opens myForm2. I can also open myForm2 from the double click event on a field from mySubform. myForm2 is set to allow additions, edits, deletions and filters.
The button on myForm opens myForm2 using docmd with acFormAdd and opens to a new record. The double click event on mySubForm opens myForm2 in acWindowNormal, not specified but I read it's the default. There is a where condition in this case, opening the form to a specific record using a PK from myForm and FK from myForm2.
The button is for adding new records and the double click is for editing existing records, which I'm sure you've all gathered at this point.
This works brilliantly through testing and for a good amount of time. Then, suddenly, the property for myForm2 switches to "dataEntry" mode causing my double click event to open to a new record instead of specific record. No error appears, it just opens to a new record. I switch it back and it works great for a while and then switches again. This has happened about 3 or 4 times now and I can't figure it out.
I should add that I had originally created myForm2 with the dataEntry property set to yes but switched it to no soon after. I don't know if that is playing a role. Also, if it matters, myForm2 is a popup modal. Not sure if that matters as well
Thank you.