how to transform text to code

[HENDRY_del_FUEGO via AccessMonster.com]

Hi all,

I am struggling with the following:
(i posted this question also in the query module, sorry if this is not
correct..)

I have made a table where a define Case / Description Case / SQL-code
The sql-code is the correct code (with [table]!... etc.) which need to be
checked if a record belongs to case 1 , case 2 , etc.

I want the code for these codes all togheter in a table to make it easier for
my successor to maintain it.

Now the problem:
In a query I make the following check:
Case 6: IIf([Overview cases]![SQL-code],"OK","NOK")

This does not work because access sees the test as TEXT, how can I make it
clear to access that this [Overview cases]![SQL-code] is sql code?

thanks in advance

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-modules/200711/1