Preview stuck in loop when parameters chosen out of order

[olichap]

Hello all,

I've a report with your typical date params, a CompanyType, and a CompanyName (which is based upon the CompanyType), and Product.

The order of selection is this:
DateFrom
DateTO
CompanyType
Company
Product

If the user jumps down to Product, clicks on the drop-down for the combo, the development environment seems to get stuck in some sort of loop (preview form constantly blinks and never finishes process).
This also occurs when I set a default value for CompanyType (defaulting to the first in the list) that causes the CompanyName combo to be populated. Initially a user could not select a CompanyName until the CompanyType was selected (the CompanyName stored proc is based upon CompanyType).

Now if I change the defaulted CompanyType to something else in the list the same loop/freeze occurs.

Anyone else seen this sort of problem?

Thanks,
O.

 

[Catadmin]

Check the code on all your datasets to make sure you haven't inadvertantly caught yourself in an infinate loop cursor or While statement (or something).

Also, verify your parameters aren't set up in a recursive reference loop. Diagram it out on a piece of paper to be sure. The last thing you want the params to be doing (or the datasets) is something like

A
/ \
B----C



Catadmin - MCDBA, MCSA
"If a person is Microsoft Certified, does that mean that Microsoft pays the bills for the funny white jackets that tie in the back???