Assigning Values to Non AutoSearch Criteria

rbuser

Hi there

Is it at all possible to assign values to criteria which have not been
set to AutoSearch within the Calc tab?

I have criteria which will be used twice in a report but would like to
spare the user from having to input the same values. I have been able
to do this when the criteria is AutoSearch however this leaves room
for user error and makes the report inconsistent.

TIA
Steve

nicocizik

Steve,

It is possible to change the search criteria automatically at run-time using
DADE. Below is a link to an example demonstrating how to do this.

http://www.digital-metaphors.com/tips/ChangeSearchCriteriaviaSQL.zip

--