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

mNo edit summary
mNo edit summary
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:  
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]]):  


[[File:Close notes run time error.gif|alt=Microsoft Visual Basic Run-time error '-2147352567 (80020009)': The data has been changed. ]]
[[File:Close notes run time error.gif|alt=Microsoft Visual Basic Run-time error '-2147352567 (80020009)': The data has been changed. ]]
:: Run-time error '-2147352567 (8020009)':
:: The data has been changed


I can't replicate this in my test version. Who all gets this, and does anyone know how to make it happen consistently?
== When does this happen? ==
*I get it whenever I enter something on the notes field and then exit it but do not have a [[WBC]] entered.--[[User:CMarks|CMarks]] 07:23, 2017 November 1 (CDT)
The error seems to happen if the Notes form is closed when certain Apache fields are not filled out yet.  
*I get it whenever I close the notes field  --[[User:Jvelasco|Jvelasco]] 07:39, 2017 November 6 (CST)


=== Fix ===
Some Apache fields are subject to [[Check APACHE physiological variable high low]] (if they are in an unlikely range, an entry in Notes is required). For Medicine collectors thisis often the [[WBC]] field. It appears that this somehow triggers the error, but I don't understand how and have not been able to fix it. Ttenbergen 10:44, 2019 September 12 (CDT)
Added a .requery before the code that runs cross checks against the new contents of the notes field.  
 
== Fix ==
*2019-09-11 - Joyce demonstrated this is still a problem.
*2017 sometime - Added a .requery before the code that runs cross checks against the new contents of the notes field.  


== Related articles ==
== Related articles ==
{{Related Articles}}
{{Related Articles}}