>Any time you need
fresh data in View2, you first need to requery View1 or open View1 with data. Just issuing a Requery() on View2 or opening View2 after View1 is opened will not implicitly trigger a requery() on View1.
Mark,
This is exactly what I was looking for: '... you first need to requery view1 or open view2 with data.'
I cannot open view1 with data since I don't know which data the user wishes to use in the report. When I know which data it is, it can be multiple values. Since I know of no way to create a multi-valued view parameter (which is usually the integer primary key value ) I populated view1 from the multi-select list prior to requerying view2, which didn't work.
So it brings me back to this:
For a view (view2) based on a view to work, the based-on view (view1) must be directly populated from the underlying table via either a requery or open with data and NOT manually poplulated. Is this correct?
Gil Munk
"If a nation expects to be ignorant and free, it expects what never was and never will be." - Thomas Jefferson