Running queries on new record and record modification

  • Thread starter Thread starter John
  • Start date Start date
J

John

Hi

I need to run a query when a new record is inserted and another one when a
record is modified. What events do I need to trap?

Thanks

Regards
 
Not enough information but the Form_AfterUpdate Event will fire on new
Record as well as Update.

You may also like to check out the Form_AfterInsert Event also.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Select Record in query, save as New Record then edit New Record 1
time stamp record without overwriting previous time 1
see Deleted # after run Delete and append query 1
forms: modification date field 4
Query Parameter using multiple options 0
How does one eliminate blank records on a query result? 3
Record insert/delete anomaly 0
Run code on records appended automatically with query 6

Back
Top