Dual Table update

[Steve]

Hello,

I'm trying to add the same record to two different tables from a form
and I'm at my wits end. The record would most likely have a different record
ID in each table as the tables are identical in fields only. One table is
the master and the working table contains only data pertinent to today.

A little help please
Steve

[Bogdan Zamfir]

Hi,

You need to create a recordset based on the other table (not one you have
the form bound to)
In either BeforeUpdate or AfterUpdate events of the form, you create the
recordset from your second tabe, add a record and fill it with data from
your form.

Suppose you have the following TextBoxes on your form:

txtName
txtAddress

In form_AfterUpdate you could add the following code (suppose you want to
add this to table TodayPersons)

set rs = db.OpenRecordset("TodayPersons")
rs.AddNew
rs!name = me.txtName
rs!Address = me.txtAddress
rs.Update

HTH,
Bogdan Zamfir
______________________________
Independent Consultant
"Steve" <ac******@netins.net> wrote in message
news:bq**********@news.netins.net...

Hello,

I'm trying to add the same record to two different tables from a form
and I'm at my wits end. The record would most likely have a different record ID in each table as the tables are identical in fields only. One table is
the master and the working table contains only data pertinent to today.

A little help please
Steve