Filter Records on Tab Control

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

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