'VBA Access SQL Updating two fields in subform based on a selection

I have a subform containing a table reference from MS SQL SERVER. When user changing some data I need to change data in two fields: LastDateChange and Spelialist.

In one case - user changing data in one row - and in that case I use Form_AfterUpdate event which works well.

In the other case - user can copy and paste data from external Source. In that case event is not working. I need with updated of piece of the referenced table to update fields LastDateChange and Specialist.

How can I do that without using trigger update on this table?

sql-servervbams-access


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions