Filter two tables from one form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How would I make this happen? I have two tables, Company Information, and
Products. On a single form, I want to have two command buttons that will
filter these tables. One will filter Company information, and the other will
filter Products.

Is this possible?
 
Create two queries, one for each table.
In each query create a reference to the text box in the form

QueryName1:
Select ProductTableName.* From ProductTableName Where FieldName =
Forms![MainForm]![TextBoxName]

QueryName2:
Select CompanyTableName.* From CompanyTableName Where FieldName =
Forms![MainForm]![TextBoxName]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I access a second table from a form? 6
Filter Field Selection from Previous Field 2
Access Determine what query to run based on a checkbox 0
Update Two Tables Using One Form Contents 0
Filter Form doesn't close 2
subform w/ datasheet view 5
Filtering based on data in another table 2
Combo Boxes that filter database 3

Back
Top