You do know that the semicolon ";" is the end-of-line indicator for SQL... ????
You have:
Code:
SELECT Table1.Question, Table1.Answer, Table1.Tags1, Table1.CopyCount
FROM Table1; <<<---------
WHERE (((Table1.Question) Is Null Or (Table1.Question) Like "*" & Forms!AllTablesHome!Text1 & "*") And ((Table1.Answer) Is Null Or (Table1.Answer) Like "*" & Forms!AlltablesHome!Text3 & "*") And ((Table1.Tags1) Is Null Or (Table1.Tags1) Like "*" & Forms!AlltablesHome!Combo25 & "*"))
UNION
<snip>
Try deleting the ";" after each of the table names:
Code:
SELECT Table1.Question, Table1.Answer, Table1.Tags1, Table1.CopyCount
FROM Table1
WHERE (((Table1.Question) Is Null Or (Table1.Question) Like "*" & Forms!AllTablesHome!Text1 & "*") And ((Table1.Answer) Is Null Or (Table1.Answer) Like "*" & Forms!AlltablesHome!Text3 & "*") And ((Table1.Tags1) Is Null Or (Table1.Tags1) Like "*" & Forms!AlltablesHome!Combo25 & "*"))
UNION
SELECT Table2.Question, Table2.Answer, Table2.Tags1, Table2.CopyCount
FROM Table2
WHERE (((Table2.Question) Is Null Or (Table2.Question) Like "*" & Forms!AllTablesHome!Text1 & "*") And ((Table2.Answer) Is Null Or (Table2.Answer) Like "*" & Forms!AlltablesHome!Text3 & "*") And ((Table2.Tags1) Is Null Or (Table2.Tags1) Like "*" & Forms!AlltablesHome!Combo25 & "*"))
UNION
SELECT Table3.Question, Table3.Answer, Table3.Tags1, Table3.CopyCount
FROM Table3
WHERE (((Table3.Question) Is Null Or (Table3.Question) Like "*" & Forms!AllTablesHome!Text1 & "*") And ((Table3.Answer) Is Null Or (Table3.Answer) Like "*" & Forms!AlltablesHome!Text3 & "*") And ((Table3.Tags1) Is Null Or (Table3.Tags1) Like "*" & Forms!AlltablesHome!Combo25 & "*"))