Filtering subform based on another subform

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

Guest

Hi All,

I have a main form that contains 2 subforms: Main, sub01, sub02

The main form is just a holding place for the 2 subforms. The forms are not
bound to each other.

Sub01’s source is Query1 and is a continuous form.

Sub02’s source is Table01 and is a continuous form.

I would like to have a button on Sub02 that will filter this subform based
on 3 fields in the record that I have currently selected in sub01. (Maybe a
toggle that will filter and unfilter Sub02.)

For example:

The record I am currently on in Sub01 has: AcctNo 78910, ItemNo 5555, and
ProjectNo 123456

I need to filter sub02 so only the records with the matching fields of
AcctNo, ItemNo, and ProjectNo show.

Any help would be greatly appreciated.

Thanks, Rachel
 
Back
Top