Automatically run Append Query When adding record

[cruzan1]

I have a form to add systems to a systems table. And I have an append query called QuestionSystem that adds to an answer table. How would I run this query from my add systems table?

 

[PHV]

Perhaps in the AfterInsert event procedure of the form ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[cruzan1]

It worked thanks.
I copied the SQL from the query and pasted it in a RunSQL macro using AfterInsert.

cruzan