Hello,
I am using Access 2000 and would like to have the data in 3 tables (1,2,3)appended into a new table (tblTest) . The user would then select a criteria from a form ,using tblTest, press a button and have the result from table 1,2 or 3 in list boxes (3). Some data would be in all tables.
Thanks

Try using ADO to append the record into the new table and then refresh the list boxes.

Mihai

Ex:

Dim cnx as New ADODB.Connection
Dim str as String

Set cnx = CurrentProject.Connection
'Define str as the SQL statement that appends the record to table Temp, dependind on the conditions you want, like this

If cond1 Then
str = "INSERT INTO tblTest (Field1, Field2, ...)" & _
"SELECT Field1, Field2, ... FROM table1 ..."

cnx.Execute str
Set cnx= Nothing

'And then refresh the list boxes

Why not just use a union query

select * from table1
union
select * from table2
union
select * from table3;

What you really need is the result, not a table.



Sal