Parameterize Comparison Operators?

[jjturner]

In the design grid, I'm using a reference to a value in a form's combo box as criteria. Short of using code, is it possible to have the preceding comparison operator for the criteria be user-defined at run-time?

In other words, is there a way to let the user choose between criteria "= 'Jones'", "< 'Jones'", or "> 'Jones'"?

Any insight greatly appreciated.

TIA,
John (using A2K)

 

[llkhoutx]

You accomplish this by building a SQL statement string based uypon your form criteria.