ADP frontend - How to update a row added by a trigger

I have been setting up an Access ADP front end with SQL server back
end.
I have defined triggers on some tables to audit changes to these
tables.
When a row is deleted, I need to record who requested the change.
I have created a procedure that will do this and it works sucessfully
if I test it from the from end by calling the stored procedure directly
from the database window for an existing record.

However, when the procedure gets called at run time using an ADODB
command, the row is not getting updated.
I have checked if the new row is visible from the front end when the
procedure is called, and have found that it is not there.

Is there a command that will force a requery of the table without
having to close and reopen the connection?

VivN

re: ADP frontend - How to update a row added by a trigger

How are you showing the data in the front end? datagrid, listbox?

re: ADP frontend - How to update a row added by a trigger

The audit data is not viewed from the same form that generated the
audit record.
I opened the audit table from the ADP database window to check if the
new record was visible.
I just realised that I am trying to update the record from within the
FormDelete event - I guess the new row won't exist until the event has
completed.