>I have a check box subclass that has several properties based on the deleted() status of the current record in a table. I have added a property to the class, TableName, where I put the name of the table that the check box properties refer to. What I am trying to do in the properties sheet of the subclass is set forecolor, value and the caption using iif(). For example:
> Caption = iif(deleted(This.TableName),"Deleted","Delete")
> Value = iif(deleted(This.TableName),1,0)
>How can I get deleted() to use the actual value of This.TableName? I have tried stuff like deleted(eval(This.Tablename)), but to no avail.
>
>TIA.
I just tested and had no problem with it. One thing that throws it off... don't include the alias name in quotes in the property sheet.
BTW- I tested with your code _exactly_ except I stored the table name in .tag.
Erik Moore
Clientelligence