two tables, linking same data

[michellerobinso]

ok i have two tables.

the main table tblquery and the second tblreturns

i want the data from tbl query

return number
date received
date processed

to be the same in the tbl returns is this possible?

 

[neileg]

Why do you want to save the same data in two different places?

 

[Krij]

ok i have two tables.

the main table tblquery and the second tblreturns

i want the data from tbl query

return number
date received
date processed

to be the same in the tbl returns is this possible?

Yes, these seems very suspicious!

Anyway...do an INSERT INTO after the update of last field or make a button with the following code:

Dim strFilter As string

strFilter = "INSERT INTO tblreturns(returnnumber, datereceived,dateprocessed) " _
& "SELECT returnnumber, datereceived,dateprocessed " _
& FROM tblquery " _
& WHERE returnnumber = " & Me!returnnumber

CurrentDb.Execute strFilter, dbFailOnError

Geir Smevig-Baardsen
MCP
http://www.geirb.info
*******************
*Don't reply to my
*email.
*Reply to group
*
*
*
*******************