Run-time error when closing the Notes field: Difference between revisions

(2 intermediate revisions by the same user not shown)

Line 1:

The following error intermittently shows up for some collectors when using the '''Close Form''' button to exit out of the [[Notes field]] form (ie the form that opens when you double-click the [[Notes field]]):

Line 12:

== Fix ==

* 2022-05-31 - updated Private Sub Command1_Click() that closes the Notes form to requery the notes field

*2019-09-16 - The requery meant that collectors would be booted out of the record and into a blank one each time leaving the notes field - worse than the original bug. So, reverted that change, and bug persists.

*2019-09-12 - Joyce demonstrated this is still a problem. Restored the requery, but as a form_view.requery rather than a docmd.requery

*2018-10-30 - took out the requery because it was "causing other issues" (there is no record of what issues); after that this is still a problem, but Tina forgot to change this error report for it

*2017 sometime - Added a .requery before the code that runs cross ~~checks~~ against the new contents of the notes field.

*2017 sometime - Added a .requery before the code that runs [[cross check]]s against the new contents of the notes field.

== Related articles ==

@@ Line 1: / Line 1: @@
-{{Fixed bug}}
+{{Bug}}
 The following error intermittently shows up for some collectors when using the '''Close Form''' button to exit out of the [[Notes field]] form (ie the form that opens when you double-click the [[Notes field]]):
@@ Line 12: / Line 12: @@
 == Fix ==
+* 2022-05-31 - updated Private Sub Command1_Click() that closes the Notes form to requery the notes field
+*2019-09-16 - The requery meant that collectors would be booted out of the record and into a blank one each time leaving the notes field - worse than the original bug. So, reverted that change, and bug persists.
 *2019-09-12 - Joyce demonstrated this is still a problem. Restored the requery, but as a form_view.requery rather than a docmd.requery
 *2018-10-30 - took out the requery because it was "causing other issues" (there is no record of what issues); after that this is still a problem, but Tina forgot to change this error report for it
-*2017 sometime - Added a .requery before the code that runs cross checks against the new contents of the notes field.
+*2017 sometime - Added a .requery before the code that runs [[cross check]]s against the new contents of the notes field.
 == Related articles ==
 {{Related Articles}}