Search results for query: *

MajP, Thanks again very much. After I added "me.dirty = false" as the first executable line, the subroutine worked as I had intended in all the scenarios that I needed and described to you earlier. Using CurrentDB did not work, but thanks for giving me another option.

MajP, Thanks very much. When I inserted the "Me.dirty = false" executable statement in the subroutine, it worked in all the scenarios we've discussed. It worked both when I called it from AfterUpdate and LostFocus. Do you have any thoughts about why the new Compare_Ratio values were not...

MAJ P, Thanks for sticking with me on this. Developing this Access application is not my day job. My responses to your questions are in CAPS below: MAJP:So if I understand correctly it works when moving between records, but not when moving within a record. SCARYCS: THAT'S CORRECT. IT WORKS...

MajP, I implemented your suggested code above with a few enhancements from the LostFocus event of the Compare_Ratio field of the subform. When I hit ENTER or moved to (clicked on) another field in the same record, the value of Compare_Ratio was not updated in that record by the time that any...

I'm having trouble getting the AfterUpdate and LostFocus events of a text box on a subform to work properly (at least to work as I expect). The textbox in question is one called Compare_Ratio in the Child_Node_Compare_Datasheet subform within the Nodes_In_This_Project form...