Search results

These 2 SQL alone works: (1) SELECT DatumCas, PridelTypOperace("zmìna") AS TypOperace, PridelHodnotyOperace("zmìna", Zaznam, "Støedisko",StrediskoOLD,StrediskoNEW) AS HodnotyOperace FROM [Monitorování zmìn - Evidence PC/Støedisko] (2) SELECT DatumCas, PridelTypOperace("zmìna") AS TypOperace...

These 2 SQL alone works: (1) SELECT DatumCas, PridelTypOperace("zmìna") AS TypOperace, PridelHodnotyOperace("zmìna", Zaznam, "Støedisko",StrediskoOLD,StrediskoNEW) AS HodnotyOperace FROM [Monitorování zmìn - Evidence PC/Støedisko] (2) SELECT DatumCas, PridelTypOperace("zmìna") AS TypOperace...

I am desperate. I make use of BeforeUpdate Sub of the form to handle data changes on the record. The problem is that BeforeUpdate does not fire when there is a change from/to NULL value in the text field. But when I try to use BeforeUpdate for the particular TextBox, the BeforeUpdates fires...