Filter two tables from one form

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Daniel - 07 May 2007 21:45 GMT

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?

Reply to this Message

Ofer Cohen - 08 May 2007 11:14 GMT

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]

Signature

Good Luck
BS"D

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

Reply to this Message