How to filter a form by a query that is based on 2 tables?

[drinkwater]

Hi
Hope some experts can help me with this simple question.
I have two tables in my database (too many variables to be able to put into one big table): table A and table B (one to one relationship). I created a form with table A as source table, and created a subform on it with Table B as the subform data source. Now I want to filter the forms (both main and sub forms) by a query based on both table A and table B. For example I want to choose records with tableA_var1="eat" and tableB_var1="Lunch", does anyone know how to write the VBA codes for this?
Thanks.


Drinkwater

[June7]

How would you use a query to filter forms? Use comboboxes on form to input parameters. Use these parameters to set filters for the forms. Filter each form with respective criteria. For one approach, review tutorials at http://datapigtechnologies.com/AccessMain.htm especially the two on Search/Filter forms in the Access Forms: Tips & Techniques section.

You have more than 255 fields? Never seen a table that big. Possibly your data structure is not normalized.