Hi all,

I am still quite new at Access so if there is a solution that does not
require intense coding in VB i'd prefer that soln, unless VB is
absolutely necessary.

Description:

I am a separate table set up to store data for each individual
department (or Business Unit). they are all the same structure with
same fields. As more data comes into each table, there are likihoods of
duplication of records so i am creating this database to sort out
duplicates WITHIN each individual Business Unit.... as well as have the
capability to check ACROSS different (user-selected) business units for
duplications.

Problem:

I have a Temp table set up with the same structure that will be used to
run my queries from. From a form that has a Combo box, the user will
select which Business Unit (or BU) to check for duplicate records. I
would like the queries to be able to read the selected text (as it is
the same string as each BU's Table Name), as the table to use in the
query. Is it possible to do this so that the same query can be used
repeatedly based on what the user selects from the combo box?
Basically, i am thinking that if i have dozens of BU's sending me data,
I dont want to create the "same" query over and over for each BU. I
want a query that can contain a variable to represent which Tables to
use. so, i am not sure if what I want to do is possible since when i
try to create a query I can only select existing tables from the lists
and not use an expression to point to my stored selection from the
combo box.

If there is a way, what's the logical solution to make this work?
Thanks
Herman