save a record in two different tables

[spkr70]

How do I save a record (on a form) into two different tables at the same time?
Not an expert,but more than a beginner

[PEB]

Hi,

You need An append Query... Create it from the Query Designer

In the macros use OpenQuery macro and assign your Append query

Then in your form in the respective event that fit you assign this macro!

:)

[spkr70]

Hi,

You need An append Query... Create it from the Query Designer

In the macros use OpenQuery macro and assign your Append query

Then in your form in the respective event that fit you assign this macro!

:)

Hi PEB,
Thanks for your reply.
I've had a go at Append,but I don't want the "messages" displayed.I want to click on the "Close Form" button & have the Save procedure run in the background.
info: I'm entering new data via the form.When finished entering data,I click on button "close Form" & data is saved to main Table.I used basic method(macro builder) ie Close formInspect,& Save.Here is the problem.The main table contains data about machinery,some machinery needs repaired.Faulty machinery is tagged "FAULTY" & after I repair faulty the record is Updated & tagged "NOT FAULTY".I now don't have a Historic record of equipment which was faulty.That's why I need two tables.One table(Main Table) which has updateable fields & another table(Historic) to keep a record of all that was faulty.
Ideally,I would like to click on "Close Form" & the data would be saved to the Main Table,& at the same time,filter the records tagged "FAULTY" & save these to the Historic Table.Does that make sense to you?