Right Tables????

[Steve B]

I have 21 separate bill of material tables.I am trying to
design a a form or switchboard that will run a run a query
that I have made.The query runs a comparison on two tables
and identifies differences.The question I have is how I
can create a form or switchboard so that I can have the
user type in the two different models and click on a
button and have it automatically find the two correct
tables to compare and query them????

Thanks ahead of time for any assistance
Steve B
..

 

[BJ Freeman]

one way is to use the switchboard to call a vba routine.
in the routine you can have dialog boxer(s) that get the models defined.
then use that to run your query.