straybullet
IS-IT--Management
...when button on form is clicked. Let me explain. The form has a combobox which allows selection of a group of products(by zone such as Lighting Gallery, Bath Concepts, Kitchen Showcase, etc).
Once a zone is selected, the user can then either click a button to open the report which displays the entire contents of the zone, or they can use a separate combobox to select the specific section of the zone they wish to view.
Everything seems to work fine except Kitchen Showcase. If I choose a section, there is no problem, however when I click the button to view the entire zone, instead of it opening, I get the following message:
"This expression is typed incorrectly, or it is too complex to be evaluated." etc...
The underlying query works fine if I enter the criteria manually.
Im stumped, because earlier today it was working just fine!![[sadeyes]](/data/assets/smilies/sadeyes.gif "[sadeyes] [sadeyes]")
The only change I have made was to implement user level security - which shouldnt have affected this one report's ability to display a specific set of information anyway... Incidentally, this error is occuring for members of each group of users.
Any suggestions?
(and you all thought you were going to have an entire day without having to deal with one of my little "issues" lol
Let them hate - so long as they fear... Lucius Accius
Once a zone is selected, the user can then either click a button to open the report which displays the entire contents of the zone, or they can use a separate combobox to select the specific section of the zone they wish to view.
Everything seems to work fine except Kitchen Showcase. If I choose a section, there is no problem, however when I click the button to view the entire zone, instead of it opening, I get the following message:
"This expression is typed incorrectly, or it is too complex to be evaluated." etc...
The underlying query works fine if I enter the criteria manually.
Im stumped, because earlier today it was working just fine!
The only change I have made was to implement user level security - which shouldnt have affected this one report's ability to display a specific set of information anyway... Incidentally, this error is occuring for members of each group of users.
Any suggestions?
(and you all thought you were going to have an entire day without having to deal with one of my little "issues" lol
Let them hate - so long as they fear... Lucius Accius
