Filter two tables from one form

D

Daniel

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?
 
O

Ofer Cohen

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]
 
Top