Right Tables????

  • Thread starter Thread starter Steve B
  • Start date Start date
S

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
..
 
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.
 
Back
Top