>>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.

Just to clarify: iif(deleted(This.Tag),1,0) in the .Value property. and for the .Tag property you just put the tablename (MyTable instead of ="MyTable")

Thanks