Filters

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

Guest

Hi,

How would I create a filter that runs whenever a subform is running within a
form. I basically want the filter to show only records where the category is
equal to one.

I have eight categories and one subform for each. I can filter the view by
right clicking on the category text box when the subform is visible to only
show the category I want but I want it to do it automatically.

Thanks
 
burg said:
How would I create a filter that runs whenever a subform is running within a
form. I basically want the filter to show only records where the category is
equal to one.

I have eight categories and one subform for each. I can filter the view by
right clicking on the category text box when the subform is visible to only
show the category I want but I want it to do it automatically.
Click to expand...


Not sure I understand what the 8 subforms are doing? Are
they all visible at the same time?? Or are you doing
something to make them come and go along with changes to the
category value?

You should at least try using the Link Master/Child
properties to synchronize the subform to the text box.
Without more details, I sounds like you can just set the
Link Master property to the main form's Category text box
control and the Link Child property to the subform's
category field (not a text box control).

If that doesn't fit whatever you're doing, you can add a
text box with the expression =1 and use that for the link
master.
 
Back
Top