Filter Records on Tab Control

[Guest]

How do you filter records on a tab control?

I have a form with a tab control that contains two pages. The first page
contains information from one table and the second page contains a subform
with information from a related table.

I have been unsuccessful at filtering the records using a combo box and a
filter statement and have tried setting the focus to the tab control first.

Can someone point me to some help for doing this?

Thanks,

Arlene

 

[Allen Browne]

Does the combo filter a field from the main form's table, or a field from
the subform's table?

If the main form, you can just set the Filter property of the main form
(remembering to set FilterOn as well.)

If you want to filter the main form so that it only contains records that
have a match in one of the subform's fields, see:
Filter a Form on a Field in a Subform
at:
http://allenbrowne.com/ser-28.html

 

[Guest]

Thanks again Allen. I'll take a look at the link.