I created a local parameterized view with 4 tables each linked through the use of primary and foreign keys. When I browse the view and enter the value it works properly and I get the data I expect. When I place it in code in an FWX, set the value of the view parameter then issue a =REQUERY(), no records are located. I have local parameterized views all thoughout my applications and never had this problem. The only difference is that this is the first view I have created with 4 tables. I cannot understand how it works using the project manager browse versus within code using the same value for the parameter. Anyone have any ideas?

 

 

Joe