Find the right tables to Query????

  • 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
 
Create a form with two comboboxes for the user's selection of comparison
items.

In the code behind the button, incorporate into the query the values from
the comboboxes.

For example:

strSql = "Select * from Customers WHERE CustomerID = " & cboCustomer


--
HTH,

Steve Clark, Access MVP
FMS, Inc.
Professional Solutions Group
http://www.FMSInc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Is your Access database too slow?
Are you ready to upgrade to SQL Server?
Contact us for optimization and/or upsizing!
http://www.FMSInc.com/consulting
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
 
Back
Top