hi,
This is a suggestion and might not be the answer.
Cant we use a trigger on that table which fires on insert on that table.
Call the stored procedure in the trigger.
Below is the example
CREATE OR REPLACE my_procedure
(p_variable1 IN my_table.column1%type,
p_variable2 IN my_table.column2%type,
p_out OUT number)
AS
BEGIN
p_out := p_variable1 + p_variable2;
END;
/
CREATE OR REPLACE TRIGGER my_test_trigger
BEFORE INSERT ON my_table
DECLARE
v_out number;
BEGIN
my_procedure(:new.column1, :new.column2, v_out);
:new.column3 := v_out;
END;
/
This example is in oracle.
Iam not sure of this example in MS Access.But there must a way doing this.
Hope this helps.