can comparison criteria be saved in a table?

[markjkubicki]

i have a table that i use to store control names, comparison criteria, related record I.D.s, field names, etc.



the field names would be: Note_Cntrl, Note_Criteria, Note_ID, Note_Field, etc...

(the different fields are used in different places, in different combinations throughout the project; this is to reduce redundancy in code)



Typical code using these values would be like this:

if you're at control ___, check field ___, in table ___, for this criterion ___



for most records, the criteria is a simple:
...True or False (-1 or 0)
for a select few, the criteria is more difficult:
... InStr(Nz(Forms!frmSpec.controls(strControl_Name), ""), "0-10") > 0 And Forms!frmSpec.chkDimmableYN


the code that this info is fed into would be:

          strNote_Control = gsRst! Note_Cntrl
          strNote_Criteria = gsRST!Note_Criteria
          if Forms!frmSpec.Controls(strNote_Cntrl) = strNote_Criteria then
                ... (do something)

This work fine for Boolean criteria;

However, for the more complicated criteria, it’s comparing against the criteria ***as a sting value***, not as an evaluation of that criteria

• How can I deal with the eval of the more difficult criteria?
  
• Is this an effective approach ?
  

As always, with thnx in advance,
m.

[CJ_London]

store the complete criteria

InStr(Nz(Forms!frmSpec.controls(strControl_Name), ""), "0-10") > 0

will evaluate to true/false

could also be written as

Nz(Forms!frmSpec.controls(strControl_Name),"") Like "*0-10*"

[markjkubicki]

thinking to myself... "how do i get this to EVALuate the string as a formula";

so... with no knowledge of, i tried EVAL()
TaDa!!!!
exactly what i was looking for

also simplified the criteria formulas... (like stop looking for a value that is in the same table/record as the formula being evaluated, just include the value in in the formula first place...)
(but that's an aside, the answer i was looking for: EVAL() !)

[CJ_London]

actually I thought you were already using the Eval function - otherwise would have mentioned it

good luck!